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

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'.