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.

[TABLE="width: 832"]
<colgroup><col span="3"><col><col><col></colgroup><tbody>[TR]
[TD]Year[/TD]
[TD]Month[/TD]
[TD]Day[/TD]
[TD]Date[/TD]
[TD]Group[/TD]
[TD]ACD Calls Accepted[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]Friday, January 02, 2015[/TD]
[TD]Customer Service[/TD]
[TD] 835[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]Friday, January 02, 2015[/TD]
[TD]Cutomer Care General[/TD]
[TD] 132[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]Friday, January 02, 2015[/TD]
[TD]Emergency Technical Support[/TD]
[TD] 799[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]Friday, January 02, 2015[/TD]
[TD]Technical Support[/TD]
[TD] 769[/TD]
[/TR]
</tbody>[/TABLE]

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)