Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
W O W ! ! !
Thanks to all for the immediate response. The adjustment to the formula did the trick. "Dave" wrote in message ... Hi, Your data may be contaminated with spaces. To test for this, temporarily modify your formula to: =COUNTIF(B2:B21,"*X*") Does that change the count? Regards - Dave. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use of the COUNTIF function | Excel Worksheet Functions | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
help with the countif function!! | Excel Worksheet Functions |