Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF problem
I am using countif to check for the occurence of a string of text but as the
range of cells is using data from another spreadsheet it doesn't recognise the text as text. How do I get round this? It worls in previous versions of excel but not in 2007 for some reason. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF problem
Do you mean a wildcard search as below with *
=COUNTIF(A:A,"*searchword*") If this post helps click Yes --------------- Jacob Skaria "kitbanting" wrote: I am using countif to check for the occurence of a string of text but as the range of cells is using data from another spreadsheet it doesn't recognise the text as text. How do I get round this? It worls in previous versions of excel but not in 2007 for some reason. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF problem
No,
the formula is for example "=COUNTIF(B3:B37,teams!A13)" where teams is a list of 20 three letter values and the value in the range is for example "=Players!B4", where the screen value is one of the 20 teams. If I replace the value of B4 with the text value it is OK. I have been using this same spreadsheet with Excell 2000 for years but have recently upgraded to 2007 so I don't know if there is something new that I have missed. "Jacob Skaria" wrote: Do you mean a wildcard search as below with * =COUNTIF(A:A,"*searchword*") If this post helps click Yes --------------- Jacob Skaria "kitbanting" wrote: I am using countif to check for the occurence of a string of text but as the range of cells is using data from another spreadsheet it doesn't recognise the text as text. How do I get round this? It worls in previous versions of excel but not in 2007 for some reason. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF problem
Check whether the below works
=COUNTIF(B3:B37,Trim(teams!A13)) OR =COUNTIF(B3:B37,"*" & Trim(teams!A13) & "*") If this post helps click Yes --------------- Jacob Skaria "kitbanting" wrote: No, the formula is for example "=COUNTIF(B3:B37,teams!A13)" where teams is a list of 20 three letter values and the value in the range is for example "=Players!B4", where the screen value is one of the 20 teams. If I replace the value of B4 with the text value it is OK. I have been using this same spreadsheet with Excell 2000 for years but have recently upgraded to 2007 so I don't know if there is something new that I have missed. "Jacob Skaria" wrote: Do you mean a wildcard search as below with * =COUNTIF(A:A,"*searchword*") If this post helps click Yes --------------- Jacob Skaria "kitbanting" wrote: I am using countif to check for the occurence of a string of text but as the range of cells is using data from another spreadsheet it doesn't recognise the text as text. How do I get round this? It worls in previous versions of excel but not in 2007 for some reason. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Problem | Excel Discussion (Misc queries) | |||
SUM COUNTIF problem | Excel Worksheet Functions | |||
countif problem | Excel Worksheet Functions | |||
countif problem. | New Users to Excel | |||
CountIF problem | Excel Discussion (Misc queries) |