Sum with Index and Match or Vlookup?

[gd6noob]

Hi guys,

If you guys could help me it would be great.

so basically I have a spreadsheet of Daily SLA that needs # of Cases and Cases Processed added.
I couldnt figure out and I have searched google and youtube.

Column A just has the name of the Task (i.e. Logging voicemail SLA#1) because index/match doesnt work with merged cells.

I want the sum of each SLA at the bottom here. Originally I just added each cell but updates and more SLA were being added that editing them manually is time consuming =SUM(H18,H19,H20,H21,H22,H24,H92,H93,H94,H95).

the SLAs and Site (YYZ1, etc) are all scattered throughout the chart.
i.e. Logging voicemail SLA#1 are row 18-24 and 92-94 but are sorted by sites (YYZ1,YYZ2,etc)

If this is possible or if there is a better way, please let me know.

Much appreciated.

Thank you in advanced.

 

[Gerald Higgins]

Re: Help with using Sum with Index and Match or Vlookup?

Hi, give us an example of what exactly you want the results to be, and how that result is calculated.