IF Formulas and Summing Results

  • Thread starter WilliamsDeLisle
  • Start date
W

WilliamsDeLisle

HOW do you calculate the totals in a range of cells with IF formula results?
 
W

WilliamsDeLisle

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
 
M

Marcelo

are you looking for sumif function?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"WilliamsDeLisle" escreveu:
 
A

Ashish Mathur

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
 
W

WilliamsDeLisle

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!!!
 

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
MS Project. Real progress of the project, % complete 1
Copy addition formula of non-consecutive horizontal cells 2
Can I add a formula or function to Vlookup? 1
Multiple Columns in Sum Range using SUMIFS 1
Copy the content of a cell with Formula 1
Select a range not equal to: 4
Auto Sum not working correctly 1

Top