=Sum(((Range1=value1/cell1)+(Range1=value2/cell2))*(Range2)
The above formula works fine it will sum Range2 where values in Range1 are
matching with cell1/value1 OR cell2/value.
My question is what if i have to compare values in Range1 with 10 or more
cells/values. currently it works by repeating the conditions say 10 times,
but this will make formula much bigger. Is there any way Range1 can be
compared with cell1, cell2,...cell10 at the same time.