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. |
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. |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com