Q: How do i SUM the results of [=IF('Input Results'!E5=1,"1","0")] this equation in Microsoft Excel 2007? The following doesn't work [=SUM('Input Results'!C6:L6)]
A: Remove the quotes around the "1" and "0". The SUM() function might not add these because the quotes mark them as text and not numbers. Also, check out the COUNTIF formula. It might make life easier for you.