View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phuser[_2_] phuser[_2_] is offline
external usenet poster
 
Posts: 14
Default Specifing Cells to Sum on Condition

I have a spreasheet that contains data for 3 years

Jan 2006 Jan 2007 Jan 2008
50 50 0

Etc. Etc

All the months are populated for 2006 & 2007

But 2008 only has cells populate to June

I would like to sum only the rows for 2006 & 2007 up to the same YTD as 2008

The columns are there for 2008 there are just no numbers populated.

Is this possible?