View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Calculate totals by fields

Sounds like the Data Subtotals feature should do as you want. Just sort
the data by Expense, then by date before using it......

Vaya con Dios,
Chuck, CABGx3



"Gre" wrote:

I have a large spreadsheet of expenses. One of the columns contains items
such as telephone, travel, subsistence etc. I wish to be able to calculate
the totals for each type of expense.

The rows need to be presented in date order, but I do not need automatic
updating if that makes it easier.

Any help appreciated!