Summary of weekly data

[BCarter]

I work for a small trucking company. I have a workbook that has
worksheet for each truck. Each workbook is for a quarter of the year
Each worksheet lists the date that fuel was purchased, the number o
gallons, the cost of gallons purchased and the cost of the fue
purchased. I want to take that data for each truck and have i
summarize for the week. I then want to take each trucks data and hav
it go to another worksheet that gives all of the totals listed abov
for each truck to get totals for my entire fleet. Any suggestions o
how I might achieve this?

 

[Mike Lewis]

A perfect case for a "Pivot Table".

Get all of the detail into one list with headers on top:

Truck #,Date,gallons,price,(and perhaps quarter if that is
important)

Then attach a pivot table to that list and you'll get
everything you want.

Good luck

Mike

 

[Don Guillett]

if you don't want to use a pivot table try learning the sumproduct formula
=sumproduct((date>startdate)*(date<stopdate)*(truck=whichone)*cost)
where you have a daterange a2:a200, trucks in b2:b200, cost in f2:f200