Index and match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Able to return a value by matching 2 variables from 2 tables, would like to
sum the values that match both variables. The formula only returns the 1st
value (as a look-up function)...i.e., using the 'Sumif' function but matching
2 criteria instead of one.
 
=SUMPRODUCT(--(criteria1_range="text_value"),--(Criteria2_range=num_value),sum_range)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top