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

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

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
 
Hi Cheryl

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

assuming row 50 is the last row before your Grand Total
 
Back
Top