Sum of values that meet criteria

[randomraz]

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!

[jason.b75]

It has nothing to do with lookups of any kind.

As per forum rule #1, your thread title should be descriptive of your problem, not what you think might be the solution.

Please edit your thread title to something on the lines of 'Sum of values that meet criteria' then we will be able to help you.

[randomraz]

Done and sorry.

[Kaper]

So now title is self-descriptive :-)
Use:

Please Login or Register  to view this content.

in B2 and copy down/right
Note zeros in Data. It's because in one sheet you have "Data" and in other "Data " (with a space at the end)

[Sam Capricci]

I suspect all you need is this...
=SUMIF('Monthly Costs'!$B$2:$B$11,Monthly!$A2,'Monthly Costs'!$C$2:$C$11)
but I also suspect that there is more to your request than you have indicated. AND, you don't have an "outlook" tab in the workbook, rather you have a monthly tab.

[randomraz]

Thank you very much Kasper, my hairline is grateful to your wisdom.

[Kaper]

Glad to hear so, and thanks for reputation point.
Would you be so kind, to select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.