How to add a variable in my formula

[PL dub]

Good day,

I'm using the formula below in a cell of my Sheet1.

=COUNTIFS(DATA!E:E,">45", DATA!$A:$A,">=01/01", DATA!$A:$A,"<=01/31")


What it do,

In the sheet DATA, in Column A I have one row for each days of the year.

The formula will count the number of time I have a number higher than 45 in the column E for a specific month. In that example, January.

To avoid formula manipulation by end-users, I would like to replace the "45" by a cell (for instance G:2) wehre the end user could put the number he would like without formula manipulation.

I've try the following, but it didn't work.
=COUNTIFS(DATA!E:E,>G2, DATA!$A:$A,">=01/01", DATA!$A:$A,"<=01/31")

Any suggestion would be appreciate

 

[Eric W]

Try:

=COUNTIFS(DATA!E:E,">"&G2, DATA!$A:$A,">=01/01", DATA!$A:$A,"<=01/31")

 

[Marcelo Branco]

Try

=COUNTIFS(DATA!E:E,">"&G2, DATA!$A:$A,">=01/01", DATA!$A:$A,"<=01/31")

M.

 

[Scott T]

The cell references needs to be joined the greater than sign

=COUNTIFS(data!E:E,">"&G2,....

 

[PL dub]

It's working !

Thank you guys

 

[Eric W]

Glad we could help.