Recongnizing values for Cells.

[smithbrendan32]

I have a formula =COUNTIF('Data Page 1'!AQ5:AQ20002,"<=2.5")

However, when i replace the part of the formula "<=2.5") with an actual cell destination i.e. instead of "<=2.5") i want the value to be a cell value e.g. "A5 =COUNTIF('Data Page 1'!AQ5:AQ20002,"<=A5")
(with a value of 5 in the cell A5)
however excel does not seem to recognize that there is a value of 5 in the A5cell and i keep getting a zero value.

Anyfeedback appreciated.

[starguy]

I have a formula =COUNTIF('Data Page 1'!AQ5:AQ20002,"<=2.5")

However, when i replace the part of the formula "<=2.5") with an actual cell destination i.e. instead of "<=2.5") i want the value to be a cell value e.g. "A5 =COUNTIF('Data Page 1'!AQ5:AQ20002,"<=A5")
(with a value of 5 in the cell A5)
however excel does not seem to recognize that there is a value of 5 in the A5cell and i keep getting a zero value.

Anyfeedback appreciated.

try this

=COUNTIF('Data Page 1'!AQ5:AQ20002,"<="&A5)