View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
 
Posts: 989
Default 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.