Sum Names Total of Resources Time. Help!

[midfieldgeneral11]

Hello there.

I have a list of names which are my resources on a list of projects in Column C
For each week I plug in there Timesheet numbers in the columns named in the images.
At the bottom of each week. I want a formulae which looks at the name
Sums up the days allocated to where the Individual name is in Column C is shown
You will see I did the sum with the sum formulae =SUMIF(C:C,"Annie",E:E) but I will be adding lots of names.
I copied this across to the next column and changed the formaulae to SUMIF(C:C,"Annie",F:F) but this just gave me blank numbers.
Must be an easier way.
I

 

[Alex Blakenburg]

I think I might be missing something but is this what you mean.

20210604 Sumifs simple column addition.xlsx
	C	D	E	F
2	Resource	Jun-21	24 May - 30 May	Week 1
3	Jay		0.79	1
4	Ashnu		0.99	2.01
5
6
7	Jay		0.43	2
8
9
10	Jay		0.14	1.5
11
12
13
14
15
16	Summary
17	Annie		0	0
18	Ashnu		0.99	2.01
19	Jay		1.36	4.5
Sheet1

Cell Formulas
Range	Formula
E17:F19	E17	=SUMIFS(E$3:E$13,$C$3:$C$13,$C17)