Help Please in Summing

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello.

Sorry to ask such a simple question, but I need help on
how to get a total of some cells.

Here's the sample.

If cell
A1 is 05 and is true
A3 is 10 and is true
A5 is 15 and is False
A7 is 10 and is True
A9 is 05 and is False

How can I make A11 show me the result by just adding those
numbers that are TRUE and give me the sum ?

Would really like help, thank you.
 
Hi Mike!

I assume that you have TRUE or FALSE as boolean in an adjacent cell.

If so:

=SUMIF(B1:B9,"=TRUE",A1:A9)

But the assumption may be wrong and you'll need to provide more
information.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks so much for the help. I actually didn't have it the
way you said, having "TRUE" or "FALSE" in another cell but
fixed it that way and used your formula. It worked. Thanks
again.
 
I'm not sure where your TRUE/FALSE condition is, but if
your TRUE statement were in column B, this will give you
your answer. If your true statement is somewhere else,
change the first range of cells to whatever range the true
statement is located in.

=SUMIF(B1:B5,"TRUE",A1:A9)

Hope this helps.
 
Back
Top