matty_lou82
New Member
- Joined
- Sep 14, 2018
- Messages
- 38
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.
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
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>