Oh forgot to mention, months (D34:D46) & totals (E34:E46) are on
another sheet, a summary sheet if you like.

Esra


On Aug 30, 2:05*am, Spiky wrote:
On Aug 28, 9:48 pm, Esradekan wrote:

Months to choose are in B34:B46 - thought I did state that.

Thanks anyway.

Esra

I misunderstood something, and your explanation was a bit confusing.
Is this the setup?

You have data listed in A1:[?]30; with dates in A, Staff1 in B, Staff2
in C, etc. You have a list of months in B34:B46. You want a total for
those months in C34:C46.

If that's correct, then these ought to work (and be able to be copied
for the others), although I haven't tested it:
=SUMIF(Date,$B34,Staff1)
=SUMPRODUCT(--($A$1:$A$30=$B34),B$1:B$30)

Also:
You said your Name for staff 1 is "Staff 1". That doesn't seem correct
because I don't believe Excel allows for spaces in Names. You'll have
to correct my formula with the precise Names.