2 criteria formula

[rawr19911]

I have a list of people who have multiple roles and allocations

what i need to do is like a vlookup but based off 2 rows for example

look up john and as a program manager and output his allocation.

look up john as a project manager and put out his alloication and so on

the reason for this is we have it broken out into different groups that is submited by management

 

[Joe4]

If think you can do what you want with a SUMIFS formula, matching on Name and Manager type, and summing the Allocation field.
See: SUMIFS function - Microsoft Support

 

[rawr19911]

If think you can do what you want with a SUMIFS formula, matching on Name and Manager type, and summing the Allocation field.
See: SUMIFS function - Microsoft Support

trying to get it to work- i am just not getting it

 

[rawr19911]

trying to get it to work- i am just not getting it

nevermind i got it

 

[Joe4]

trying to get it to work- i am just not getting it

OK, on the left I have the table, on the right I have the values I want to lookup:

Here is the formula I have in I1 to return that value:

=SUMIFS(D1:D6,A1:A6,G1,C1:C6,H1)

 

[rawr19911]

OK, on the left I have the table, on the right I have the values I want to lookup:
View attachment 93192

Here is the formula I have in I1 to return that value:

=SUMIFS(D1:D6,A1:A6,G1,C1:C6,H1)

your awesome- i found my mistake i typed in a column incorectly thank you for being so amazing!

 

[Joe4]

You are welcome.
Glad I was able to help!