![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() 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... |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move the data at bottom cell to right side of the cell | kcyag91 | Excel | 1 | 01-28-2016 12:28 AM |
Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |
Copying data from one cell to another where condition is third cell | fairyca | Excel | 4 | 03-30-2014 08:22 AM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |