in my worksheet i have different kind of items with its cost. in my case which is not in order, that is, the order of items
can be AABAACCBA...
I want to calculate Cumulated Total on each row. but i am not sure how to achieve this by conditional formula? the values in
my sheet looks like the following,
Date ITEM TYPE AMOUNT Cumulated Total
10-Jan-07 Book A 10 10 -value(Book)
11-Jan-07 Pen A 5 15 -value(Book+Pen)
12-Jan-07 Table B 15 15 -value(Table)
13-Jan-07 Pencil A 20 35 -value(Book+Pen+Pencil)
14-Jan-07 Chair B 25 40 -value(Table+Chair)
15-Jan-07 Sofa B 35 75 :
16-Jan-07 Rose C 20 20 :
17-Jan-07 Calc... A 30 65 :
18-Jan-07 Jasmin C 10 30 -value(Rose+Jasmin)
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Please find the attachment for reference. How to achieve this using conditional statement or lookups or someother? and
i try to avoid macro.
any help would be greately appreciated!