lookup and sumif

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Two scenarios:

1. I want to do a lookup with an exact match on more than
one criteria. For example, I want to find the value in
column C in the row where column A and column B meet some
criteria.

2. I want to find the SUM of ALL of the values in column
C where column A and column B both meet some criteria.

The criteria in A and B are different.

Please let me know how to do both scenarios. Thanks.
 
Joe,

For the sum use SUMPRODUCT:

=SUMPRODUCT((A1:A10 = "abc")*(B1:B10 = "def")*(C1:C10))
gives 15 for the data below

abc def 1
def abc 2
abc abc 3
def def 4
abc def 5
def abc 6
abc abc 7
def def 8
abc def 9
def abc 10

Dan E
 
Back
Top