E
Esradekan
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
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