Sum with Index and Match or Vlookup?

gd6noob

New Member
Joined
Oct 20, 2017
Messages
30
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.
 
Last edited:

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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.
 

Forum statistics

Threads
1,086,245
Messages
5,388,671
Members
402,134
Latest member
McKnze21

Some videos you may like

This Week's Hot Topics

Top