# Sum of values that meet criteria

1. ## Sum of values that meet criteria

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!

2. ## Re: Lookup and add

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.

3. ## Re: Lookup and add

Done and sorry.

4. ## Re: Sum of values that meet criteria

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

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)

5. ## Re: Sum of values that meet criteria

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.

6. ## Re: Sum of values that meet criteria

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

7. ## Re: Sum of values that meet criteria

Glad to hear so, and thanks for reputation point.
Thanks.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1