View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Jordan
 
Posts: n/a
Default 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?