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

15 minute data to daily data 1
I need Time Range to return Value 4
Conditional Formatting 0
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
Sum amounts based on date field 6
Countifs with different restrictions 1
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
Modifying a complex date formual to count months 4

Top