I see what you are trying to do here, but it doesn't work for my application
(the 9AM and 10AM was just an example). Is there any way to use AND/OR with
COUNTIF? Thanks.
--
Brian


"Tom Ogilvy" wrote:

=COUNTIF(B4:B27,"=9:00 am")-Countif(B4:B27,"10:00 am")

--
Regards,
Tom Ogilvy


"brianwakin" wrote in message
...
How do I use the COUNTIF and the AND functions together? I tried using
the
following formula and got an error:

=COUNTIF(and((B4:B27,"=9 am"),(B4:B27,"<=10 am")))
--
Thanks.

Brian