On Tuesday, September 17, 2013 7:28:16 PM UTC-7, joeu2004 wrote:
wrote:

This formula errors with "too few arguments".

=COUNTIFS(B2:B6="*4PM-6PM Start*",A2:A6,"<")



The "=" is a copy-and-paste typo. The formula is:



=COUNTIFS(B2:B6,"*4PM-6PM Start*",A2:A6,"<")

That does it. Interesting use of- ,A2:A6,"<")

Thanks,
Howard