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?
|