The Data Subtotals can give you each Expense separated and totaled and
sorted by it's own dates, but if you want only one big date sort, I guess
your best bet then would be to sort everything by date, and then build a
separate table using formulas based on Bob's
suggestion.......=SUMIF(A:A,"Telephone",B:B)
......replacing "Telephone" with each expense in turn.



"Gre" wrote:

Thanks for that - has taught me something new!

However... it doesn't quite do what I want - I need all the records sorted
by date, so I would need the totals in something like a summary table on
another sheet/somewhere on the same sheet.

There are only 15 or so different types of expenses, so to edit a formula
directly would not be too time consuming if that is the only way to do it.

(Of course i can sort by expense, compute the sums normally, and re-sort by
date, but i would like to know if there is a more advanced way to do it :) )

"CLR" wrote:

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!