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