COUNTA with IF in an array

W

WildWill

Hi

I need asistance with this problem:

Column A Column B
P1 08:22:00
P2 02:45:00
P1 03:15:00
P3 00:45:00
P3 11:14:00
P2 21:07:00

Column A is formated to contain Text
Column B is formated to contain hh:mm:ss data

Considering the above data set, I want to count the number of cells in
Column B which have values in them (like a COUNTA) but only where Column A =
"P3", for example. I.e. the answer will be "2" for this example.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum amounts based on date field 6
Modifying a complex date formual to count months 4
Break Calculation 1
Lookup and average data in an unsorted list 1
Complex If then? 4
Peak call times/hours 2
calculate cells with format hh:mm 4
Count entries in the column translating to minutes. 5

Top