I'm trying to compare a range of cells in one column against a range of cells in 3 other separate columns. If there is a match then provide sum of an additional column.
The logic would read as follows:
If any cell in range A1:A30 equals any cell in B1:B30, C1:C30 or D1:D30 then return sum of E1:E30.
If it matters the A, B, C & D columns would contain both a number and text (i.e. 130A, 156B, etc.), while E is strictly numbers.
Any help is greatly appreciated!!! Been racking my brain on this for a few weeks now.
Thanks in advance!!
Bookmarks