Need a formula for multiple sums in a cloumn when rows vary

[Cheryl]

I am making a invoice I need a total for each truck, with a grand total at
the end. The number of rows for each truck in the amount column will vary. Is
it possible to have the text truck total to the left of the total? A small
example below, there will be more entries under each truck and more trucks
also.

tr# date hrs rate amount
3 4/12/10 10 50 500
4/13/10 5 50 250
truck 3 total 750

4 4/10/10 1 50 50
truck 4 total 50

and so on
with a total invoice 850

 

[Roger Govier]

Hi Cheryl

The Grand Total will simply be
=SUM(E2:E50)/2

assuming row 50 is the last row before your Grand Total

 

[Ron@Buy]

Cheryl
I think the SUBTOTAL function will achieve what you require. You could try
Excel help for an explanation but Linda Johnson gives a step by step guide:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=358