View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jimswinder jimswinder is offline
external usenet poster
 
Posts: 32
Default How do I count nonblank cells that meet criteria in another ce

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?


"Domenic" wrote:

In article ,
jimswinder wrote:

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


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