# SumIF question, multiple criteria

#### Rav_Singh

##### New Member
I am attempting to summarise a large data-set and am having trouble trying to collate the sum total.

Sample of data-set is below;

 Qtrly Modified Date Docs Emails Q1-2018 15/01/2018 1 0 Q1-2018 16/01/2018 1 0 Q2-2018 17/04/2018 0 3 Q2-2018 18/05/2018 0 0 Q3-2018 19/07/2018 1 0 Q3-2018 22/08/2018 0 1 Q4-2018 23/10/2018 0 2 Q4-2018 25/12/2018 0 3

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

I would like to calculate the sum totals of 'Docs' and 'Emails' based upon the Qtrly dates.

i.e. so for the answers it should hopefully reflect the table below.

 Qtrly Docs Emails Q1-2018 2 0 Q2-2018 0 3 Q3-2018 1 1 Q4-2018 0 5

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

This seems a common formula however the different CountIF/SumIF formulas have not returned the values I was hoping for. Any help would be gratefully received.

Rav

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### Rav_Singh

##### New Member
This is exactly what I needed! Thanks for making me feel silly!

Much appreciated as always.

ABCDEFGHI
1QtrlyModified DateDocsEmailsQtrlyDocsEmails
2Q1-201815/01/201810Q1-201820
3Q1-201816/01/201810Q2-201803
4Q2-201817/04/201803Q3-201811
5Q2-201818/05/201800Q4-201805
6Q3-201819/07/201810
7Q3-201822/08/201801
8Q4-201823/10/201802
9Q4-201825/12/201803

</tbody>
Summary

Worksheet Formulas
CellFormula
H2=SUMIF(\$A:\$A,\$G2,C:C)
I2=SUMIF(\$A:\$A,\$G2,D:D)

</tbody>

<tbody>
</tbody>

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback

Replies
1
Views
143
Replies
8
Views
436
Replies
1
Views
211
Replies
4
Views
393
Replies
3
Views
295