| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |
|
|
Hybrid Mode
