Its meant to:

I want to sum the sheet so that I get the total mileage for each week.

You can put it anywhere as long as the formula isn't in the column that is
being summed. If it is, then you would have to change C:C to a specific
range such as C1:C200 and then put it below row 200.

If checks if the date in column A is greater than or equal to the start date
of the week in question. (you change the condition to something like

"=May 29, 2005"

If so, it adds the number of miles for that date

so you add up all miles that occured after or on May 31 2005

then using as similar formula, you subtract the sum of all the miles driven
after the end of the week

"Jun 4, 2005"

the difference is the number of miles you drove the week of May 29, 2005 to
Jun 4, 2004.

--
Regards,
Tom Ogilvy


"HotRod" wrote in message
...
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)