word appearance and totalling
 

I have 2 words that appear in th same column ORDER and CLOSED. I would like
at the bottom of the spread sheet a total of each word so at the bottm it
says 54 ORDERS and 105 CLOSED. Is this possible and how do I do it?

word appearance and totalling
 

=COUNTIF(<<rage,"CLOSED")

=COUNTIF(<<rage,"ORDER")

Place the abobe in each cell you wish to get the count for

"tapley" wrote:

I have 2 words that appear in th same column ORDER and CLOSED. I would like
at the bottom of the spread sheet a total of each word so at the bottm it
says 54 ORDERS and 105 CLOSED. Is this possible and how do I do it?