Fortunately for me I need a running start and a tall cliff to get my truck up
to the speed limit. I sometimes miss those carefree days of stomping on the
gas pedal, leaving some tread, and blowing off some doors. Now I'm afraid of
all the punks who drive like I used to ;-)
--mark
"T. Valko" wrote:
<humor
You'll regret this the day you get caught in a speed trap now that you've
told them the best time is to catch you! <VBG
</humor
--
Biff
Microsoft Excel MVP
"Dave O" wrote in message
...
Hi, Mark-
I wasn't sure how you wanted to include the peak and low speeds- if
you can post some sample data it would be easier to figure out. I'm
leaving for the day very shortly but if you get bogged down in
applying the peak and low speeds send me an email at cyclezen ATSIGN
yahoo daht calm. I check email there more frequently than I check
posts here.
SUMPRODUCT with the double unary operator is a powerful tool to keep
in your Excel arsenal- I learned about it at this usenet group:
http://groups.google.com/group/micro...?hl=en&lnk=srg
It amounts to a SUMIF, but allows you to many "ifs" instead of just
one- cool stuff.
Have a good weekend!
Dave O
Eschew obfuscation