Count specific Text in a range of Cell on another tab

[Shazz]

Hi,

Can Anyone help at all, need to be able count specific text (SB) in a range on another sheet tab. Can anone advise a formula.

On the Summary Tab, I want a formula in Cell L2, that counts the range K6:O6 on Sheet Tab named wk 6 if SB is in any of the cells.

Attached is an example

 

[vletm]

Shazz - for Cell L2 ... or did You mean to Cell L3?
=COUNTIF('wk 6 '!K6:O6,"SB")

 

[Shazz]

That is not working for me, it is showing what is on the attached.

Shazz

 

[vletm]

Did You press <ENTER> after copy that formula?
Here it works as below...

 

[Shazz]

What do you mean?

Shazz

 

[vletm]

Copy and Paste that formula or write it Yourself
(If You normally use =COUNTIF('wk 6 '!K6:O6,"SB") then it works ...
or if You used ; then You have to use =COUNTIF('wk 6 '!K6:O6;"SB"))
and
after that press <ENTER> to stop editing that cell.

 

[Shazz]

it is still not working, I have copied and Pasted, which is what I normally do, I have typed it myself and this is what I am getting.

 

[Shazz]

Dont worry, I have now sorted it out.

Thanks for your help.

Shazz

 

[vletm]

... good ... You copied someway one extra ) there.
... and maybe in the beginning, You could paste formula as text.