SumIF question, multiple criteria

[Rav_Singh]

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

Hopefully the below example displays correctly on this page.

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

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I
1	Qtrly	Modified Date	Docs	Emails			Qtrly	Docs	Emails
2	Q1-2018	15/01/2018	1	0			Q1-2018	2	0
3	Q1-2018	16/01/2018	1	0			Q2-2018	0	3
4	Q2-2018	17/04/2018	0	3			Q3-2018	1	1
5	Q2-2018	18/05/2018	0	0			Q4-2018	0	5
6	Q3-2018	19/07/2018	1	0
7	Q3-2018	22/08/2018	0	1
8	Q4-2018	23/10/2018	0	2
9	Q4-2018	25/12/2018	0	3
Summary

Cell Formulas
Range	Formula
H2	=SUMIF($A:$A,$G2,C:C)
I2	=SUMIF($A:$A,$G2,D:D)

 

[Rav_Singh]

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

Much appreciated as always.

How about

	A	B	C	D	E	F	G	H	I
1	Qtrly	Modified Date	Docs	Emails			Qtrly	Docs	Emails
2	Q1-2018	15/01/2018	1	0			Q1-2018	2	0
3	Q1-2018	16/01/2018	1	0			Q2-2018	0	3
4	Q2-2018	17/04/2018	0	3			Q3-2018	1	1
5	Q2-2018	18/05/2018	0	0			Q4-2018	0	5
6	Q3-2018	19/07/2018	1	0
7	Q3-2018	22/08/2018	0	1
8	Q4-2018	23/10/2018	0	2
9	Q4-2018	25/12/2018	0	3

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Summary​

Worksheet Formulas Cell Formula H2 =SUMIF($A:$A,$G2,C:C) I2 =SUMIF($A:$A,$G2,D:D) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

You're welcome & thanks for the feedback