Tom
Where would I place this "SumIF"? at the bottom of the column or in a
new row for each entry? Not sure I understand what it's meant to do?




"Tom Ogilvy" wrote in message
...
do you have a date associated with each entry? If so (assume column A
below) you can just use two sumif functions

=sumif(A:A,"=StartofWeek",C:C)-Sumif(A:A,"EndofWeek",C:C)

--
Regards,
Tom Ogilvy


"HotRod" wrote in message
...
I'm wondering if it is possible to do the following with a formula or if
I
need to create a macro. I'd prefer to stay away from the macro if
possible.


I Have a sheet that has all of my business trips on it (Sorted by Date) I
want to sum the sheet so that I get the total mileage for each week.

1) Since some weeks I travel more than others how can I determine if the
mileage belongs to week 1 or 2, for ex. One week I may have five
business
trips C5:C10 and then week two, two business trips C11:C12, but the
following month it could be reversed. So How can I get another cell to
SUM
the first week?


2) Is there a way to sort this out in a formula?

This is what I think I need to figure out

a) Set start date
b) Determine date ranges for week's 1 - 4
c)