Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|