Countif Greater than a cell reference

[beerandcrisps]

Hi

I am carrying out what I though was a simple countif, but am having problems. On one worksheet, I have the numbers 1 to 32 in row 1. In row 2 I am trying to write a countif that refers to these numbers but obviously don't want to write it 32 times. Howevere I am having problems because the countif is a greater than or = to. For the first number, if I write =COUNTIF(Sheet2'!G:G,">=1") I get the correct answer, but if I change this to =COUNTIF(Sheet2'!G:G,">=B1") it no longer works. How do I do a countif when my >= refers to a cell reference.

Cheers

Andy

 

[Jonmo1]

=COUNTIF(Sheet2'!G:G,">="&B1)

 

[VoG]

Try

=COUNTIF(Sheet2!G:G,">="&B1)

 

[brian.wethington]

=COUNTIF(Sheet2!G:G, ">=" & B1)

Hope this helps!

 

[beerandcrisps]

Thanks all - it works great.

Knew it would be a simple one but just couldn't get my head in gear.


Cheers

Andy