Adding everything but last cell

[Guest]

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

 

[Don Guillett]

one way

=SUMIF(B1:B21,2)-INDEX(B1:C21,MATCH(2,B1:B21),2)

 

[Guest]

Thanks Don for you help...really appreciated

one way

=SUMIF(B1:B21,2)-INDEX(B1:C21,MATCH(2,B1:B21),2)

 

[Don Guillett]

glad it helped