I type or click =, I then click the countif button or the arrow leading to
the countif and other choices, the error message then comes up that excel had
encountered a problem and needs to close and excel closes not saving any data
entered.
Can you help?
Mo
It sounds like you are using a generated button, driven by a macro? This
certainly is not a standard Excel option.
What happens if you type in you're formula without clicking this
Countifbutton?
If you click on <Alt><F11>, can you see any code to generate a menu item?
If so, clearly something went wrong in the macro, and you'll have to either
repair, or delete it.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.