Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
Just wondering if you canc outn the number of times it says EMPTY in your
spread sheet. It updates all the time, from numbers to empty depending on whas in the space. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
If there is a word you want to count, it can be done with the following
formula. You will need to adjust the range criteria to fit your need. =COUNTIF(A2:A5,"EMPTY") Les "Confused at Work" wrote: Just wondering if you canc outn the number of times it says EMPTY in your spread sheet. It updates all the time, from numbers to empty depending on whas in the space. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
eg: put this in a cell out outside the area (range) you want to count
the values in =COUNTIF(2:65336,"EMPTY") change 2:65336 to you range ( Eg B1:K:3000) HTH Confused at Work wrote: Just wondering if you canc outn the number of times it says EMPTY in your spread sheet. It updates all the time, from numbers to empty depending on whas in the space. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |