SUMIF Several Columns

Hi Guys,

I have a data table showing Resources and hours worked according to days.
ex.

Resource 1-Feb 2-Feb 3-Feb
James 8 5 9
Harry 5 7 2
Lloyd 6 7 4

Now, I want to sum all february for each resource, I tried:

=SUMIF(A1:A3,A1,B1:D1)

but the formula is only summing the first column.

Any ideas?

Cheers

Assuming your data is in A1:D4, and Say you list the unique names in G2:G4 and in H1 onwards you list the months as January, February, March, etc...

Then Try formula in H2:

=SUMPRODUCT((TEXT($B$1:$D$1,"mmmm")=H$1)*($A$2:$A$4=$G2),$B$2:$D$4)

copied down and across.