Thread: Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next

BCB:

Try this:

C1: =SUMPRODUCT(--ISNUMBER(1/(A2:A21*B2:B21)))

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=540522

Reply With QuoteReply With Quote