Wanting to get data from one cell and and add the data from corresponding cell
I would like excel to find numbers in a range of cells. and then gather data from cells in the same row and add them up.
e.g.
cells b1 through b 15 contain a number example 1 2 3 2 5 3 4 2 6 3 4 1
cells c1 through c15 contain a currency number 2.45, 4.36, 3,21, 4.34 8.62 so forth and so on.
I need a function the takes the number in b1 through b 15 snd then look at the info in c1 through c15 and add the numbers in c1 through c15 for each corresponding cell in b1 through b15
b2 = 2and c2 = 4.36
b4 = 2 and c4 = 4.34
the output in another cell should be 8.70
is this possible?
sorry its so long but the best way to describe it, I tried...
|