View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default {=COUNT(IF(etc))} question

Ben, sounds like an array formula, use ctrl+shift+enter to put the formula
in

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ben Karlin" <Ben wrote in message
...
This is the stupidest question you can imagine. I don't use the powerful
functions of Excel often enough that I remember them.

I got help when I needed it and now can't even remember what the question

I
asked at the time. The help I got explained that when I finished, the
function would be enclosed in curly brackets. Now I can't remember what

kind
of expression it is so I can't look up help for it. And of course when I
look at the function the curly brackets disappear and I can't remember the
key sequence to make them work again.

What do I have to do to make the function work again?

Thanks for not laughing at me.

Ben Karlin
St. Louis, Missouri