Frequency Formula - Meeting multiple criteria

[Amosbroker]

Ok - usually I can search these message boards or find a YouTube video, it's just not happening for me today. I am looking to count unique ID's in one column that meet criteria in three other columns.

Column G = "" (blank)
Column O = Completed
Column L - Coaching
Column F contains my ID's I want unique total for (there are duplicates and I only want unique/engaged)

I would like to count the unique number of ID's who meet criteria listed above.
My frequency formula keeps giving me error. Well.... my attempt at frequency formula keeps giving me error. I would be forever grateful for any advice/assistance!!!

Thanks a ton!
Angela

 

[Aladin Akyurek]

Don't you have date/times values in QueryA!$B:$B?

You can check this with an ISNUMBER test:

=ISNUMBER(QueryA!B2)