Thread
:
COUNTIF WITH NAME A RANGE OF INFORMATION
View Single Post
#
3
Posted to microsoft.public.excel.programming
JW[_2_]
external usenet poster
Posts: 638
COUNTIF WITH NAME A RANGE OF INFORMATION
You can use a Array formula to handle this. You enter these by
pressing Ctrl+Shift+Enter. Here's an example you can modify for your
needs.
=SUM((A2:A10="Cars")*(B2:B10="Black"))
When you press Ctrl+Shift+Enter, the formula will look like:
{=SUM((A2:A10="Cars")*(B2:B10="Black"))}
wrote:
I am currently using this formula in
=COUNTIF($F$6:$F$1194,"Fast") to count cells with the word "Fast",
but
how do we set it up to give a time range as well, example..
Cell A1 to A1000 have various names and one of the them is "Fast".
Cell B1 to B1000 have the delivery times.
I need to have a cell in my report COUNT the number of deliveries in
Column B that were between 00:01 to 00:05 minutes from the service
Fast in Column A
Column A has the name of the service
Column B has time range for the deliveries
Thanks
JP
Reply With Quote
JW[_2_]
View Public Profile
Find all posts by JW[_2_]