Counting Words
=COUNTIF([range you want to count],"EMPTY")
Should update automatically if your workbook is set to re-calculate
automatically, otherwise you'll have to hit F9 to update the count.
Dave
--
Brevity is the soul of wit.
"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.
|