Hello all,
I have had no luck with internet searches nor racking my brain for a solution. The basic problem is this, I have a large range of data 2000+ cells and I need to Add only the hours for a division within a department.
The division is given with a list of names. To be more clear here is an example
Name Hours
Doe 2
Smith 3
Murphy 3
Roberts 8
Mollard 4
Names belonging to Division A_
Doe
Mollard
Division A Total hours:
6
Usually i would just do a series of If statements but there is between 30 and 55 names in one division and this would be painstakingly tedious (I have to do this same thing for 13 divisions...)
Ideally I would just like to Specify my Sum Range, Specify the Criteria Range, Specify the Criteria List. Exactly like a Sumif...but the Criteria can be anyone in a list. I thought of some combination of Vlookup or match might work but have had no luck so far.
Thanks for the help,
Brewface