| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting problem
Yes! that did it! thank you so much, you just saved my operations management
grade! :) -- ~Laura~ "Domenic" wrote: Assuming that A2:A100 contains your numbers, try... =IF(COUNTIF(A2:A100,0),COUNTIF(A2:INDEX(A2:A100,MA TCH(0,A2:A100,0)),"0") ,COUNTIF(A2:A100,"0")) Hope this helps! In article , "daydreamin7" wrote: I am trying to find a way to count cells in a range, I want them to count numbers greater than 0. But when I hit the first 0 (I have it on randomization), I want it to stop counting... because the game is over for the simulation I'm dong. Any ideas what I can do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Problem with counting characters in a cell | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
| problem adding | Excel Discussion (Misc queries) | |||
Threaded Mode
