Using the value from a cell within a formula

[fauxhugo]

Hi;

I was hoping some one could assist me with formula.

=COUNTIF($F$2:$F$1914,"A2C")

Here is my formula, What I am trying to achieve is read the value from other cells

=COUNTIF($F$2:$F$1914, B11)

But when I update it the top formula... it will show 0. am i missing something ? or is there a function i am suppose to fill in...?

 

[gaz_chops]

What is in B11?

 

[fauxhugo]

it would be a string such as A2C, A2D and on

 

[gaz_chops]

Then it should work! Are there any spaces in the text in column F? Or in B11? Like "A2C "

 

[fauxhugo]

There isn't..... So in column F i have Multiple strings such as A2A, A2B, A2C.... is there another function i can use to count the amount of times the strings appeared

 

[gaz_chops]

Just to clarify, in each cell you have either A2A or A2B or A2C etc No other characters?

Can you post a sample of the data.

 

[AlanY]

see if that made any differenec

=COUNTIF($F$2:$F$1914, TRIM(CLEAN(B11))

 

[fauxhugo]

IT WORKED !!!! thank you alanY

 

[gaz_chops]

IT WORKED !!!! thank you alanY

You must have had spaces or other characters in B11.

 

[AlanY]

IT WORKED !!!! thank you alanY

glad that help, just lucky guess