Thread: Index and match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
swanrage swanrage is offline
external usenet poster
 
Posts: 2
Default 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.