IF Formulas and Summing Results

  • Thread starter Thread starter WilliamsDeLisle
  • Start date Start date
W

WilliamsDeLisle

HOW do you calculate the totals in a range of cells with IF formula results?
 
Mike H said:
Post some sample data with expected result
Click to expand...

Running total each month: IF formula in column 2 is:
=IF(July!O2=100,"10.00","0.00")

RESULTS NEEDED: 20 or 30 or 40 depending upon the monthly total in column 2

Month
Jul-08 10.00
Aug-08 10.00
Sep-08 0.00
Oct-08 0.00
Nov-08 0.00
Dec-08 0.00
Jan-09 0.00
Feb-09 0.00
Mar-09 0.00
Apr-09 0.00
May-09 0.00
Jun-09 0.00
 
are you looking for sumif function?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"WilliamsDeLisle" escreveu:
 
I can not get the SUM IF function to return any results but zero.
 
Hi,

Please remove the quote from around the numbers in the IF formula. If for
some reason you cannot do so, then you may use =SUMPRODUCT(C4:C6*1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
THANK YOU! This was such an easy solution I would hope that Excel would
incorporate it into their Help guides. I spent so much time and all it took
was removing the quotes from the numbers in the formula. You Rock!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Sum in Excel 1
formula in excel 2
Excel formula, sum the value cell and if empty cell left blank 0
IF AND Nested Functions - Formula Not Working 0
Sum formulas 3
Excel help INDEX MATCH w/ division and subtraction 0
Excel VBA 1
Formula help - Sum results Pass or Fail 8

Back
Top