VLOOKUP imbedded in SUM function-Simplify

[Nice SOP]

Below is the current formula I have that needs simplified.

=IFERROR(SUM(INDEX(Month_Range,MATCH($A79&"-"&$B79&"-Cost-US",Value_ID,0),COLUMN()-5),INDEX(Month_Range,MATCH($A79&"-"&$B79&"-Cost-APAC",Value_ID,0),COLUMN()-5),INDEX(Month_Range,MATCH($A79&"-"&$B79&"-Cost-EMEA",Value_ID,0),COLUMN()-5))/SUM(INDEX(Month_Range,MATCH($A79&"-"&$B79&"-Minutes-US",Value_ID,0),COLUMN()-5),INDEX(Month_Range,MATCH($A79&"-"&$B79&"-Minutes-APAC",Value_ID,0),COLUMN()-5),INDEX(Month_Range,MATCH($A79&"-"&$B79&"-Minutes-EMEA",Value_ID,0),COLUMN()-5)),0)

Essentially what I'm doing is using the Index/Match combonation as a subsitute for vlookup. I have a list of ID's named as "Value_ID" in name manager. The ID's have 4 componets to them, seperated by a "-". I want to sum up all values for the regions (US, APAC, and EMEA) designated in the last section of the ID. It's very tedious copying and pasting the formula only to change the region name, espicailly when i have 100+ regions. Very messy and very hard to correct errors.


Is there any way I can trick the sum function into doing this for me so my function looks much cleaner? I have all the regions as a list in name manager, maybe I could do somthing with this?

 

[CharlesChuckieCharles]

Have you looked at SUMIFS ?

 

[Nice SOP]

Interesting thought. Is there a way I could make a condition where the collumn value must be present in my regions name manager list?