Thread: Counting non blanks with SUMPRODUCT?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mifty Mifty is offline
external usenet poster
  
Posts: 99
Default Counting non blanks with SUMPRODUCT?
Hi everyone is there a way to add another bit to get this formula to only
count if cells in column A are blank?

=SUMPRODUCT((All!$C$2:$C$1205=$A8)*(All!$W$2:$W$12 05<=$Q$2))

Hoping someone can help :-)

Cheers
--
Mifty
Reply With QuoteReply With Quote