Array Formula

[Guest]

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

 

[T. Valko]

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)))

 

[Guest]

Thank you, Thank you, Thank you!

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you, Thank you, Thank you!