Thread: Sumproduct not working
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
  
Posts: 829
Default Sumproduct not working
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,"<")

Reply With QuoteReply With Quote