Hi,
I'm trying to search column A for a value, say 1 & then return a sum of the products in column B that are in the same row of the value 1
I can't seem to attach anything yet, so
A B
1 10
1 15
1 20
5 1
6 10
Cell E4 has the value of 1 - I need to search column A for the value of E4 & return the sum of the products in column B into the cell E5 e.g. sum = 45 in the example
Bookmarks