Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Function
Is there a function that will count how many times I have entered a word in a
range of cells? I tried using the count function, but that only works for numbers. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Function
Try this:
=COUNTIF(A1:A10,"word") Or, using a cell to hold the criteria: C1 = some word =COUNTIF(A1:A10,C1) -- Biff Microsoft Excel MVP "Té" wrote in message ... Is there a function that will count how many times I have entered a word in a range of cells? I tried using the count function, but that only works for numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Function | Excel Worksheet Functions | |||
count function | Excel Worksheet Functions | |||
COUNT function | Excel Worksheet Functions | |||
Count if function | Excel Worksheet Functions | |||
COUNT Function | New Users to Excel |