Thread: Using SUMPRODUCT to count values in separate columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Using SUMPRODUCT to count values in separate columns
Hi,

=SUMPRODUCT(--(K2:K66="Yes")*--(M2:M66="True"))

should do the job ...
HTH
Carim

Reply With QuoteReply With Quote