Counting number of times value exist in a column

[martyp]

Hi all,

Please can you help with something...

I have one sheet with different values in Column A. I want to check against each value in Column A to see how many times it appears in Column B of different sheets.

The COUNTIF function doesn't seem to be working?

I'm using for example:
=COUNTIF(Sept10!B2:B4000,"A4")

To see how many times the Value in A4 is matched in B2:B4000 in sheet Sept10 but it returns a value of 0 every time?

Can someone tell me what I'm doing wrong? Is COUNTIF a function that can't be used across different sheets?

Many thanks in advance

 

[VoG]

Try removing the quotes

=COUNTIF(Sept10!B2:B4000,A4)

 

[JackDanIce]

Is A4 your cell containing the value you want to count or the value itself you are trying to count? If it's the cell reference, then remove the quotes and it should work

 

[martyp]

Is A4 your cell containing the value you want to count or the value itself you are trying to count? If it's the cell reference, then remove the quotes and it should work

A4 contains the value I want to count in the other sheets in column B.
Many thanks

 

[martyp]

Try removing the quotes

=COUNTIF(Sept10!B2:B4000,A4)

That was it! Many thanks VoG, that worked perfectly.