Index and match

[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.

 

[Bob Phillips]

=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)