Formula help

  • Thread starter Confused at Work
  • Start date
C

Confused at Work

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.
 
W

WLMPilot

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
 
S

stevebriz

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)
 
Top