Array Formula
 

Hi - I'm trying to set up an array formula that will count the number of
entries for each location that has a Time Notified ie: the result should be 2
for WACH, 0 for WIMU and 1 for WMIC. I am stumped - any help would be greatly
appreciated!

Location Time Called Time Notified TAT
WACH 05:00 05:40 0:40
WACH 07:00 07:20 0:20
WIMU 06:00
forumla to return "" or TAT
WMIC 06:00 08:20 2:20
--
I.M.Confused

Array Formula
 

Try this:

=SUMPRODUCT(--(A2:A5="WACH"),--(ISNUMBER(C2:C5)))

Better to use cells to hold the criteria:

F2 = WACH

=SUMPRODUCT(--(A2:A5=F2),--(ISNUMBER(C2:C5)))



--
Biff
Microsoft Excel MVP


"Imconfused" wrote in message
...
Hi - I'm trying to set up an array formula that will count the number of
entries for each location that has a Time Notified ie: the result should
be 2
for WACH, 0 for WIMU and 1 for WMIC. I am stumped - any help would be
greatly
appreciated!

Location Time Called Time Notified TAT
WACH 05:00 05:40 0:40
WACH 07:00 07:20 0:20
WIMU 06:00
forumla to return "" or TAT
WMIC 06:00 08:20 2:20
--
I.M.Confused

Array Formula
 

Thank you, Thank you, Thank you!
--
I.M.Confused


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A2:A5="WACH"),--(ISNUMBER(C2:C5)))

Better to use cells to hold the criteria:

F2 = WACH

=SUMPRODUCT(--(A2:A5=F2),--(ISNUMBER(C2:C5)))



--
Biff
Microsoft Excel MVP


"Imconfused" wrote in message
...
Hi - I'm trying to set up an array formula that will count the number of
entries for each location that has a Time Notified ie: the result should
be 2
for WACH, 0 for WIMU and 1 for WMIC. I am stumped - any help would be
greatly
appreciated!

Location Time Called Time Notified TAT
WACH 05:00 05:40 0:40
WACH 07:00 07:20 0:20
WIMU 06:00
forumla to return "" or TAT
WMIC 06:00 08:20 2:20
--
I.M.Confused

Array Formula
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Imconfused" wrote in message
...
Thank you, Thank you, Thank you!
--
I.M.Confused


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A2:A5="WACH"),--(ISNUMBER(C2:C5)))

Better to use cells to hold the criteria:

F2 = WACH

=SUMPRODUCT(--(A2:A5=F2),--(ISNUMBER(C2:C5)))



--
Biff
Microsoft Excel MVP


"Imconfused" wrote in message
...
Hi - I'm trying to set up an array formula that will count the number
of
entries for each location that has a Time Notified ie: the result
should
be 2
for WACH, 0 for WIMU and 1 for WMIC. I am stumped - any help would be
greatly
appreciated!

Location Time Called Time Notified TAT
WACH 05:00 05:40 0:40
WACH 07:00 07:20 0:20
WIMU 06:00
forumla to return "" or TAT
WMIC 06:00 08:20 2:20
--
I.M.Confused