You can use the CountIf function:

=COUNTIF(A1:X1000,"=EMPTY")
--
Kevin Backmann


"Confused at Work" wrote:

I have all the same words in a excel huge spreadsheet, just wondering on how
I can count all the ones that say the word EMPTY, and they do change
everyday, so I need them to update automatically. Thanks I always appreciate
everyones help.