Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing a Formula
I am using the following formula to add up a series of cells by a specific
month. The formula is: =SUMPRODUCT((MONTH(RBS!A$2:A$1038)=5)*(RBS!N$2:O$1 038)) I now wish to add up the cells by month and year. For example April 08, May 08 etc. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing a Formula
Include a YEAR() test as well as your MONTH() test.
-- David Biddulph "Mark" wrote in message ... I am using the following formula to add up a series of cells by a specific month. The formula is: =SUMPRODUCT((MONTH(RBS!A$2:A$1038)=5)*(RBS!N$2:O$1 038)) I now wish to add up the cells by month and year. For example April 08, May 08 etc. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing a Formula
You can do that like this:
=SUMPRODUCT((YEAR(RBS!A$2:A$1038)=2008)*(MONTH(RBS !A$2:A$1038)=4)*(RBS! N$2:O$1038)) for April 2008. Hope this helps. Pete On Sep 18, 3:07*pm, Mark wrote: I am using the following formula to add up a series of cells by a specific month. The formula is: =SUMPRODUCT((MONTH(RBS!A$2:A$1038)=5)*(RBS!N$2:O$1 038)) I now wish to add up the cells by month and year. For example April 08, May 08 etc. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with changing a formula | Excel Worksheet Functions | |||
how to edit formula without changing formula of each cell | Excel Worksheet Functions | |||
Changing Formula | Excel Discussion (Misc queries) | |||
Changing a Formula | Excel Worksheet Functions | |||
Copy Formula Down Without Changing Entire Formula | Excel Discussion (Misc queries) |