Sumifs or Countifs question

[Dazzybeeguy]

I want to add a formula to C2 to calculate a sum when the criteria from A2 & B2 is met. So the count should be 3 - TIA

Book1
	A	B	C	D	E	F	G	H	I
1	Staff Member	Shift Type	Count
2	Joe Bloggs	EDO
3
4
5	Teams	Staff Member	Grade	Sun 05 Jan	Mon 06 Jan	Tue-07-Jan	Wed-08-Jan	Thu 09 Jan	Fri-10-Jan
6	Team 1	Joanne Bloggs	A
7	Team 2	Joe Bloggs	B	EDO	AL	EDO	LDO	ES	EDO
8	Team 3	Arthur Man	B	S
9	Team 4	Joe Bloggs	C
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D5	Dates Occurring	today	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$B$5:$B$17

 

[Fluff]

How about

=sumproduct((b6:b10=a2)*(d6:I10=b2))

 

[Dazzybeeguy]

How about

=sumproduct((b6:b10=a2)*(d6:I10=b2))

Thanks, that does it

 

[Fluff]

You're welcome & thanks for the feedback.