|
IF Formulas and Summing Results
HOW do you calculate the totals in a range of cells with IF formula results?
|
IF Formulas and Summing Results
Post some sample data with expected result
"WilliamsDeLisle" wrote: HOW do you calculate the totals in a range of cells with IF formula results? |
IF Formulas and Summing Results
"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 |
IF Formulas and Summing Results
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 |
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 |
IF Formulas and Summing Results
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 "WilliamsDeLisle" wrote in message ... "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 |
IF Formulas and Summing Results
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!!! "Ashish Mathur" wrote: 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 "WilliamsDeLisle" wrote in message ... "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 |
IF Formulas and Summing Results
you are welcome. Thank you for the feedback
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "WilliamsDeLisle" wrote in message ... 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!!! "Ashish Mathur" wrote: 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 "WilliamsDeLisle" wrote in message ... "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 |
| All times are GMT +1. The time now is 01:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com