Im lost and a little frustrated
I have two different worksheets
On sheet one I have a list of numbers in column E 1,3,4,6,78...
On sheet two I have a list of numbers in column C 1,2,3,4,5,6..... and a cooresponding set of values in column b
Im looking for a way to sum the cooresponding values into one cell for only the figures that match the numbers on the first sheet
If that doesnt make sence think of it like this
On sheet one I have a list of specific product numbers in column F(not in any specific order)
On sheet 2 I have a list of all products in column C and the quantity of each of those products I have sold in column B. I want to get a sum of only the products listed in sheet one sold in a single cell without modifying the data.
Bookmarks