see response to your posting in woksheet.functions

Please do not multipost, as it wastes a lot of time as people do not know
that you have already received an answer.

--
Regards
Roger Govier

"wild turkey no9" wrote in message
...
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