Thread: How do I count nonblank cells that meet criteria in another cell?
View Single Post
  #13   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
How come the formula did not work until I did the CONTROL +SHIFT+ENTER??

"Domenic" wrote:

In article ,
jimswinder wrote:

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 indicates that you've entered the array formula correctly. For
additional information, see the help menu under 'array formula'.

Reply With QuoteReply With Quote