=SUMPRODUCT((YEAR(A2:A20)=2008)*(MONTH(A2:A20)=3)* (B2:AE20))

--
__________________________________
HTH

Bob

"Esradekan" wrote in message
...
I have a summary sheet of 30 staff (staff 1, staff 2 etc at top of
columns), dates down the A Column with figures in the relevant cells.
What I need is a formula to get "Totals" for months. Dates down the
left are weekly dates and range is named "Date", Figures under Staff 1
is named "Staff 1", Staff 2 is named "Staff 2" etc. I have the months
listed in cells B34:B46 and want the total for the relevant months in
C34:C36.

I just want the formula for "staff 1", I should be able to work the
rest out from that.

Any help would be appreciated.

TIA
Esra