Need help totalling columns that have multiple if commands

There's too much stuff in there!!

Please calculate some expected answers, put them in the sheet, tell us where they are, and how you calculated them manually.

Be an idea if you gave us a clue which cells you are adding up and where you want the total

Formula:

Please Login or Register  to view this content.

will return FALSE if none of the conditions are met.
It should be:

Formula:

Please Login or Register  to view this content.

But note also that this will return Text value because the numbers are in quotes. So, it really should be:

Formula:

Please Login or Register  to view this content.

There's a load more brackets than you need. It isn't necessary to put an open bracket in front of each IF. But it won't do any harm, I don't think anyway.

It not lack of knowledge... you know what you're looking at, we don't. So you need to tell us!!

As TMS said:

=IF(AP2=0.75,0,(IF(AP2=1,1,(IF(AP2=1.25,0,(IF(AP2=1.5,1,(IF(AP2=1.75,1,(IF(AP2=2,2,(IF(AP2=2.25,1,(IF(AP2=2.5,2,(IF(AP2=2.75,2,(IF(AP2=3,3,(IF(AP2=-0.25,"","")))))))))))))))))))))

(this is from AQ) willl return real numbers, not text. Then a simple =SUM(J:J)

returns your total. Tone for AQ/column J.

And BTW in formulas such as =SUM(AA980-S980+300) (BRAINS sheet) the SUM function is not necessary =AA980-S980+300 is perfect

An alternative (not as sensible as removing the problem "", but quicker) purple cells.

=--BRAINS!AR2

copied down and then the SUM works fine. The longer way - removing all those quotation marks is BY FAR the better approach.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.