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.