Sumifs Formula Help 2 Criteria i think

[zone709]

Looking to get a total sum if 2 Criteria’s match.

Look at Row number 1

I need to match ID number 5 in Column D and also the job name called 153 5th if located in H,L,P,T,X,AA or AD. Then giving me total sums of the numbers in column E,I,M,Q,U,Y,AB.

You can see in Row 1. ID# 5 is in column D and the job name 153 5th matches also which would return the total of 16 because 8 and 8 are in column E and I and the job name matchs in H and L 153 5th.

Result in AF would be 16.

Hope I explained it right.

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​	S​	T​	U​	V​	W​	X​	Y​	Z​	AA​	AB​	AC​	AD​	AE​	AF​
1​	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​	S​	T​	U​	V​	W​	X​	Y​	Z​	AA​	AB​	AC​	AD​		AF​
2​	1​	Jose	Labor	5​	8.00​	​	​	153 5th​	8.00​	​	​	153 5th​	8.00​	​	​	225 5th​	8.00​	​	​	100 1st​	8.00​	​	​	100 1st​	​	​	​	6.00​	​	100 1st​		16​
3​	2​	Jose	Labor	7​	8.00​	​	​	153 5th​	8.00​	​	​	153 5th​	​	​	​	​	8.00​	​	​	100 1st​	8.00​	​	​	100 1st​	​	​	​	​	​	​		​
4​	3​	Jose	Labor	8​	8.00​	​	​	153 5th​	8.00​	​	​	153 5th​	8.00​	​	​	225 5th​	​	​	​	​	​	​	​	​	5.00​	​	100 1st​	6.00​	​	100 1st​		​

Sheet: Sheet1

 

[zone709]

=SUMIFS(E2:E11,D2:D11,”5”,H2:H11,”153 5th”) This works but i think i have to keep adding on to this to go accross +