N
nymyth
I have an excel file which i have sorted by column 'Ordered Item'.
Next to this column is a 'Price' column. The 'Ordered Item' Column
may have duplicates. What I need to do is put a subtotal beside each
group of 'Ordered Items' (even if they are single items). How would I
sum the Prices every time there is a change in the data in column
'Ordered Items'?
Ordered Items Price
241 50
241 50
340 25
600 100
600 100
So if the sheet looks like this, how can I sum or subtotal the price
column whenever there is a change in data in the Ordered Items
column. So sum of 241 shows up 100, 340 shows up as 25 and 600 shows
up as 200.
Thanks.
Next to this column is a 'Price' column. The 'Ordered Item' Column
may have duplicates. What I need to do is put a subtotal beside each
group of 'Ordered Items' (even if they are single items). How would I
sum the Prices every time there is a change in the data in column
'Ordered Items'?
Ordered Items Price
241 50
241 50
340 25
600 100
600 100
So if the sheet looks like this, how can I sum or subtotal the price
column whenever there is a change in data in the Ordered Items
column. So sum of 241 shows up 100, 340 shows up as 25 and 600 shows
up as 200.
Thanks.