Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding everything but last cell
Hi
Col A contains serial numbers. These maybe be repeated Col B Contains Dates Col C Contains Price Serial 123 12-03-05 50.25 123 13-03-05 45.20 123 14-03-05 50.15 123 15-03-05 30.20 456 11-04-05 15.25 456 12-04-05 41.25 789 08-02-05 16.20 789 09-02-05 12.30 789 12-02-05 15.30 How can I sum up each of the prices except the last one in each case? the answer for serial 123 should be 145.60 the answer for serial 456 should be 15.25 the answer for serial 789 should be 28.50 Any help appreciated |
#3
|
|||
|
|||
Thanks Don for you help...really appreciated
"Don Guillett" wrote: one way =SUMIF(B1:B21,2)-INDEX(B1:C21,MATCH(2,B1:B21),2) -- Don Guillett SalesAid Software "Anthony Slater" wrote in message ... Hi Col A contains serial numbers. These maybe be repeated Col B Contains Dates Col C Contains Price Serial 123 12-03-05 50.25 123 13-03-05 45.20 123 14-03-05 50.15 123 15-03-05 30.20 456 11-04-05 15.25 456 12-04-05 41.25 789 08-02-05 16.20 789 09-02-05 12.30 789 12-02-05 15.30 How can I sum up each of the prices except the last one in each case? the answer for serial 123 should be 145.60 the answer for serial 456 should be 15.25 the answer for serial 789 should be 28.50 Any help appreciated |
#4
|
|||
|
|||
glad it helped
-- Don Guillett SalesAid Software "Anthony Slater" wrote in message ... Thanks Don for you help...really appreciated "Don Guillett" wrote: one way =SUMIF(B1:B21,2)-INDEX(B1:C21,MATCH(2,B1:B21),2) -- Don Guillett SalesAid Software "Anthony Slater" wrote in message ... Hi Col A contains serial numbers. These maybe be repeated Col B Contains Dates Col C Contains Price Serial 123 12-03-05 50.25 123 13-03-05 45.20 123 14-03-05 50.15 123 15-03-05 30.20 456 11-04-05 15.25 456 12-04-05 41.25 789 08-02-05 16.20 789 09-02-05 12.30 789 12-02-05 15.30 How can I sum up each of the prices except the last one in each case? the answer for serial 123 should be 145.60 the answer for serial 456 should be 15.25 the answer for serial 789 should be 28.50 Any help appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Adding Comments to a Cell | Excel Discussion (Misc queries) | |||
adding zeros to a cell | Excel Discussion (Misc queries) | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Adding Value within a single cell... | Excel Worksheet Functions |