Can someone please tell me the right formula/function required to achieve the below? I suspect it’s VLOOKUP or some kind of IF function but it’s got me stumped.
I’d like Cell B2 in the “Outlook” tab to look at the entire table “Monthly Costs” tab, identify all instances of “Infrastructure” in column B and wherever it finds them to add up the corresponding value in Column C and return the sum of all of those numbers to Cell B2 in the “outlook” tab.
Is this possible?
Any help would be greatly appreciated and save some of my already diminishing hair!
Bookmarks