F
Finance Guru
Hi All,
Can some help. I am using Excel 2007
I have 3 columns
A B C
Invoice Amount Sub Total
D1000 50.00
D1000 1250.00
D1200 5000.00
D1200 1250.00
D1300 750.00
D1300 999.90
My question is this - how can I using the SUBTOTAL function in Excel,get it
to subtotal the total value for each item in Col A and put the subtotal of
these occurences in Column C. eg. in Column C for D1000 = 1300.00, D1200 =
6250.00 etc.
I have tried every way but I can only get excel to put the subtotal amount
in Col B after the end of each occurence of the totalled invoice numbers.Can
anyone assist?
Many thanks
FinanceGuru
Can some help. I am using Excel 2007
I have 3 columns
A B C
Invoice Amount Sub Total
D1000 50.00
D1000 1250.00
D1200 5000.00
D1200 1250.00
D1300 750.00
D1300 999.90
My question is this - how can I using the SUBTOTAL function in Excel,get it
to subtotal the total value for each item in Col A and put the subtotal of
these occurences in Column C. eg. in Column C for D1000 = 1300.00, D1200 =
6250.00 etc.
I have tried every way but I can only get excel to put the subtotal amount
in Col B after the end of each occurence of the totalled invoice numbers.Can
anyone assist?
Many thanks
FinanceGuru