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.

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.

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.