Question:

Sum the results of an equation in Microsoft Excel 2007?

by  |  earlier

0 LIKES UnLike

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)]

 Tags:

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating

  1. 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.

You're reading: Sum the results of an equation in Microsoft Excel 2007?

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now
Unanswered Questions