IF Formulas and Summing Results
I can not get the SUM IF function to return any results but zero.
"Marcelo" wrote:
are you looking for sumif function?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"WilliamsDeLisle" escreveu:
"Mike H" wrote:
Post some sample data with expected result
"WilliamsDeLisle" wrote:
HOW do you calculate the totals in a range of cells with IF formula results?
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
|