Replace Number by cell.

[Nailyk]

Hello everyone.
I have a question.
Right now I have this formula.


=COUNTIF('Results No Edit'!C5:D200;">=4")


But I want to replace the number for with a cell, that doesn't it work but I don,t know why.

Could someone help me please.

Edit: I changed the command to COUNTIF, First I posted the dutch formula.

[63falcondude]

If 4 was in A1, you would change your formula from

=COUNTIF('Results No Edit'!C5:D200;">=4")

to

=COUNTIF('Results No Edit'!C5:D200;">="&A1)

[Estevaoba]

Try this:

Assuming D4 is your cell.
=AANTAL.ALS('Results No Edit'!C5:D200;">="&D4

[Nailyk]

If 4 was in A1, you would change your formula from

=COUNTIF('Results No Edit'!C5:D200;">=4")

to

=COUNTIF('Results No Edit'!C5:D200;">="&A1)

Try this:

Assuming D4 is your cell.
=AANTAL.ALS('Results No Edit'!C5:D200;">="&D4

Well I did not know the & sign needed to be there?
Could you explain why.
And thanks btw.

[63falcondude]

The & sign is a concatenation tool that combines multiple sections of formulas.

Anything inside of quotes is seen as text but you need the formula to see A1 as a cell reference and not as text.

This is the syntax that Excel requires to make this happen.