Thread: How do I count nonblank cells that meet criteria in another cell?
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default How do I count nonblank cells that meet criteria in another ce
"jimswinder" wrote in message
...

"Domenic" wrote:

In article ,
jimswinder wrote:

an incorrect result...it always comes up as "0"

Are you confirming the formula with CONTROL+SHIFT+ENTER?

Sorry...I didn't know about the CONTROL+SHIFT+ENTER.

When I do that, it doe now work, but it has put brackets { } around the
whole formula. What does that mean?

It means it's an array formula.
--
David Biddulph


Reply With QuoteReply With Quote