View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wild turkey no9 wild turkey no9 is offline
external usenet poster
 
Posts: 20
Default Multi Worksheet Sumproduct Excel 2003

I just cannot solve this one. Any help you can give is much appreciated......

There are 12 sheets labled Jan, Feb Mar etc. Each sheet has the following

Col A - Name
Col C - Data to be summed

On a summary sheet I would like to able to do the following : -

For a particular month, say May, and a particular Name, sum all of the Col C
data
for the preceeding months (in this case from worksheets Jan to April).

Thanks in advance

Kevin