Index and match
 

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.

Index and match
 

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

"swanrage" wrote in message
...
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.