If you enter the date in a column as well it would be an easy summation
formula. Otherwise what rule determines that Sunday is A17 or A17:A21?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Terry" wrote in message
...
I have set up a weekly workbook which records mileage, amount of fuel,
hours
worked to name a few. What I'm trying to achieve is I send drivers out
each
day to different location. I have a sheet for each location, but
collections
very at each location each day so Sunday may be A17:A21 Monday A22:A30
which
is fine to enter for that week but the following week Sunday may be A17
and
Monday A18:A21. I need to obtain total Mileage, toatal fuel used and total
hours for each day.

"Bob Phillips" wrote:

You need to clarify what you mean by select. A formula cannot be used to
work out all instances of a day and then select them in the classic
sense,
but it can say add all items for a particular day.

More detail, and example data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Terry" wrote in message
...
hi trying to select days of week in spreadsheet amount of each day
varies
each week and would like to use formula instead of manually etering
cell
references each day.