How to get sub total in excel

Closed
ram - 9 Oct 2009 à 09:31
 Blocked Profile - 13 Oct 2009 à 04:58
Hello,
plz help me in getting sub total, for following example

Reg exp

ab01 11
ab01 10
ab01 9 sub total=30
ab02 8
ab02 7
ab02 6 sub total=21
cb01 5
cb01 4
cb01 3 sub total=12
cb02 2
cb02 2 sub total=04


here reg is automatically cumming from report.
i am want automatically sum the exp with respect Reg
Related:

1 response

Blocked Profile
13 Oct 2009 à 04:58
Dear Sir,

You will have to check the appropriate existing columns in the Add SubTotal option.

You will hence have the proper column to choose for each of the changes you make.

You will have to specify the change, select sum. Also check the to replace current

subtotals and to have a summary below data.

Thanks in advance.