COUNTIF <>= Referencing a specific cell

[nighthalcyon]

Hi all, I'm trying to count the number of occurences in a column of data that are over the number 22 (or however many business days there end up being in a month).

My formula now is: =COUNTIF(E12:E1104,">=22") and it works just fine...

But just out of curiosity, could I have a special cell called "Business Days in the Month" in Cell A1, and then reference that cell in my formula? I would imagine it would look something like this, but I can't get it to work: =COUNTIF(E12:E1104,">=A1)

Thanks.

[shammi_Raj]

simple solutoin could be an 'countifs'.
Also you can use array with countif to get the same of you have month column next to it.

A exmaple of what you are trying to acheive would give better idea.

[XOR LX]

Actually you were nearly right - just need to change the syntax slightly:

=COUNTIF(E12:E1104,">="&A1)

Regards

[nighthalcyon]

Actually you were nearly right - just need to change the syntax slightly:

=COUNTIF(E12:E1104,">="&A1)

Regards

That was exactly it. I didn't realize I needed that "&" symbol there. Thanks very much !!