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;
<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.
<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
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