Thread: ignore cells that are blank
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Robert Robert is offline
external usenet poster
  
Posts: 193
Default ignore cells that are blank
Interestingly, this one DOES work:

=SUMPRODUCT(--(J46:J522<""),--(J46:J522<L4))+SUMPRODUCT(--(J46:J522<""),--(J46:J522L3))

Reply With QuoteReply With Quote