Thread
:
How do I stop counting?
View Single Post
#
5
Posted to microsoft.public.excel.charting
Don Guillett
external usenet poster
Posts: 10,124
How do I stop counting?
=MIN(5,COUNTIF(B9:U9, "0"))
--
Don Guillett
SalesAid Software
"damanwitdaplan" wrote in message
...
I have a row of cells from B9:U9. In AA9 I currently have the following
forumula
=COUNTIF(B9:U9, "0")
I want it to stop counting at 5. I would like there to be a message saying
that you can't go to 6.
Thank you in advance for your help.
"Don Guillett" wrote:
Perhaps you could tell us a bit more?
--
Don Guillett
SalesAid Software
"damanwitdaplan" wrote in
message
...
I have a row of cells and excel is counting how many numbers there are
above
0. I want excel to stop counting at 5. Is there any way I can have a
message
come up when it hits 5?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett