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!

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!

To sum by type

=SUMIF(A:A,"Telephone",B:B)

what do you mean by presented in date order.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gre" wrote in message
...
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!

Have a look in the help index for SUBTOTAL and/or SUMIF

--
Don Guillett
SalesAid Software

"Gre" wrote in message
...
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!

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!

Thanks very much both of your; SUMIF is what i needed.

(Date order; i want the original data presented so they are sorted by date
of expense - this is also allowed with SUMIF :) )

"Bob Phillips" wrote:

To sum by type

=SUMIF(A:A,"Telephone",B:B)

what do you mean by presented in date order.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gre" wrote in message
...
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!

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!