Thread: conditional counts across columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven Stovall Steven Stovall is offline
external usenet poster
  
Posts: 3
Default conditional counts across columns
"Bob Phillips" wrote in message ...
Steve,

This sounds like a simple

=SUMPRODUCT(--(M1:M100J1:J100))

--

That did the trick. I'm brand new to this stuff and I appreciate the help.

Steven Stovall
Reply With QuoteReply With Quote