LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Counting occurrence of day of week AND hour of day

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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Max value for each day, and hour of that occurrence Rich Excel Discussion (Misc queries) 2 December 5th 07 09:45 PM
Counting occurrences in one column based on an occurrence in anoth Jim Jackson Excel Worksheet Functions 12 March 3rd 06 11:10 PM
Counting the number of cells within a certain hour. Joker Excel Discussion (Misc queries) 10 February 18th 06 03:04 PM
Calculating a colmun to total a 40 hour work week Harley mom Excel Worksheet Functions 3 December 20th 05 07:41 PM
Counting Occurrence of Text within Text in Cells in Range. Jeremy N. Excel Worksheet Functions 1 September 8th 05 05:16 AM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"