Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Please help me to set up a formula that counts # of words in column
for example: top top riser riser riser riser base top top top riser base TOP BASE RISER TOTAL: Thank you!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Try this:
For a list of words in A1:A100 This formula counts the number of cells that contain ONLY the single word "top" D1: =COUNTIF($A$1:$A$100,"top") If you put the word "top" in cell C1 then you could use this: D1: =COUNTIF($A$1:$A$100,C1) This formula counts the number of cells that contain the word "top" anywhere in the cell (eg "top shelf" in a cell would count as 1 occurrence): D1: =COUNTIF($A$1:$A$100,"*top*") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "soniadufferin" wrote: Please help me to set up a formula that counts # of words in column for example: top top riser riser riser riser base top top top riser base TOP BASE RISER TOTAL: Thank you!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Try these:
=COUNTIF(A1:A100,"top") =COUNTIF(A1:A100,"riser") =COUNTIF(A1:A100,"base") Adjust the range to fit your needs. HTH, Elkar "soniadufferin" wrote: Please help me to set up a formula that counts # of words in column for example: top top riser riser riser riser base top top top riser base TOP BASE RISER TOTAL: Thank you!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |