I guess the best explanation of subtotals would be from Microsoft itself.
Here is a link to their literature.
http://office.microsoft.com/en-us/as...097981033.aspx

Basically, you choose terms to group by (sounds like customers in your case)
and apply a sum or other mathematical function at this level. A subtotal
wiill appear below the grouping and a grand total at the end (which is the
sum of the subtotals.) After you have applied subtotals to your worksheet you
can change which level of detail you would like to show. You could show all
of the data which would be all of the individual bills the customer has, or
you could show subtotals which would be each individual customers totals, or
a grand total which would be the sum of all the customers. Hopefully this
helps some.

"dk" wrote:

we are not trying to hide cells we would like to delete it all the way just
keep the subtotatals?
also please advise how subtotals will work?

"RJ" wrote:

It sounds like you should set up subtotals on the workbook. Then you can move
up and down based on the amount of detail you need. The subtotals and
grandtotals will remain in the same cells even when you hide the detail by
moving to a more general level. To put subtotals on, select the range of data
and then go to Data -- Subtotals.

"dk" wrote:

How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items