Counting Text Pulled With A formula

[karmaimages]

Hi,

I have a list of columns in a sheet, which pulls a "Pass" or "Fail" from other sheets, I want to add a count on the word pass but this isn't working, it's displaying a zero value.

The formula that I tried was =countif(B:B, "Pass")

I suspect that because the text is pulled form another sheet this is why it isn't counting the value of the cell, how do I get around this issue?

 

[Muhammad_Usman]

Hi,

I have a list of columns in a sheet, which pulls a "Pass" or "Fail" from other sheets, I want to add a count on the word pass but this isn't working, it's displaying a zero value.

The formula that I tried was =countif(B:B, "Pass")

I suspect that because the text is pulled form another sheet this is why it isn't counting the value of the cell, how do I get around this issue?

Write Sheet name in range from where you are looking values

 

[karmaimages]

Write Sheet name in range from where you are looking values

Total is still 0

This was with =COUNTIF(Overview!B2:B51,"Pass")

 

[Muhammad_Usman]

Total is still 0

This was with =COUNTIF(Overview!B2:B51,"Pass")

Share a picture of your data if possible for batter understanding..

 

[Sufiyan97]

Your data may have leading or trailing spaces, " Pass ", if that is the case you need to remove those and if the column B in overview tab has just a sigle word, you can do it easily by replacing nothing with space.

Ctrl + H > Find What Put a pace
Replace with > Nothing

or post your data using below xl2bb link.

 

[karmaimages]

Total is the last cell.

The formula in the Pass cell there is

='Employee1'!B32

So pulls that reference from another sheet

 

[Fluff]

Assuming the image is of column B what do these two return

=len(b34)

and

=char(left(b34))

 

[karmaimages]

Assuming the image is of column B what do these two return

=len(b34)

and

=char(left(b34))

That was it, there is a space at the end of the word, whoever created the options for some dropdowns added the extra space

 

[Fluff]

Glad it's sorted & thanks for the feedback.