Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formulas and Summing Results
HOW do you calculate the totals in a range of cells with IF formula results?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing only numbers, not formulas | Excel Worksheet Functions | |||
Look up Formulas with Results | Excel Discussion (Misc queries) | |||
summing all results in a vlookup | Excel Worksheet Functions | |||
summing lookup results | Excel Discussion (Misc queries) | |||
Formulas with If/ and results | Excel Worksheet Functions |