Sumif for category and criteria

[matty_lou82]

Hi there,

I am looking to create a sumif (or sumifs) for the following data set, so that a sum is given for each name, HOWEVER with the caveat of the addioanl criteria of under a certain value. For example, the total sum of volume for Matt, but only for values less than 4.

Please can someone help, it would be really appreciated.

Name	Volume
Matt	1		Matt
Stu	5		Stu
Chris	3		Chris
Andy	4		Andy
Carl	6		Carl
Matt	7
Stu	8
Chris	3
Andy	4
Carl	5
Matt	6
Matt	8
Stu	2
Chris	3
Andy	6
Carl	7
Matt	8
Stu	3
Chris	4
Andy	5
Matt	6
Stu	8
Chris	4
Andy	5
Carl	6
Matt	8
Stu	2
Chris	3
Andy	5
Matt	3
Stu	5
Chris	2
Matt	8
Stu	6
Chris	2
Matt	1
Stu	7
TOTAL	179

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Joe4]

Assuming Name is in column A, volume is in column B, and the name "Matt" is in cell D2, put this formula in E2 and copy down for the other names:

=SUMIFS(B:B,A:A,D2,B:B,"<4")

 

[matty_lou82]

Thank you so much! Very helpful!

 

[Joe4]

You are welcome.