Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Index / Match Help | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |