Index and Match Help needed

[mistahmistah]

Hello,

I am trying to put together a yearly calculator, and would like a formula to calculate my total from year beginning to year end. Below is a small sample of data. I'd like each group to show a total number when queried against the year column since I need to calculate total ACD Calls accepted from Jan. 1 - current. This will be done in a separate worksheet from my raw data. I will then use this formula to calculate off the month column, but I can figure that out once I get the year formula. Let me know if more information is needed.

Year	Month	Day	Date	Group	ACD Calls Accepted
2015	1	2	Friday, January 02, 2015	Customer Service	835
2015	1	2	Friday, January 02, 2015	Cutomer Care General	132
2015	1	2	Friday, January 02, 2015	Emergency Technical Support	799
2015	1	2	Friday, January 02, 2015	Technical Support	769

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

Please help!

 

[Guttural]

It seems like a SUMIF is what you're after. On your new sheet you could use this code (assuming your Column A is Years and proceeding onwards):

=SUMIF(Sheet1!A:A,"2015",Sheet1!F:F)

You could even do a SUMIFS if you want to count up by Year, Month, and Group:

=SUMIFS(Sheet1!F:F,Sheet1!E:E,"Customer Service",Sheet1!A:A,2015,Sheet1!B:B,1)