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.

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

Use the "countif" function

If the range stays constant, name the range Insert-Name-Define, otherwise
high light the range internal to the formula...

assuming data exists in a range of A1:E5

the formula would be countif(A1:E5,"empty")
--
Thanks for your help -
Joe Mac


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

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.