| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I stop counting?
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop counting?
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop counting?
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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I stop counting?
damanwitdaplan:
You just need to make your Countif conditional. There are several approaches. If comes to mind: =IF(COUNTIF(B9:U12,"0")<=5,COUNTIF(b9:U12,"0"),5 ) Kelly "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| To Stop or Not to Stop | Excel Discussion (Misc queries) | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting... | Excel Worksheet Functions | |||
| How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Linear Mode
