range object

[matrixknow]

The COUNTIF works, when I use a fixed range ("A1:A100"). The range should be a variable and I use an range object. However, he types literaly "(range1, E3)" and the formula gives an error "#Name".

Please Login or Register  to view this content.

How do I need to write this ?

[adamben]

Try this:

Please Login or Register  to view this content.

[matrixknow]

Any other ideas ? This is not working.

[adamben]

Sorry left off the "" "" quotes, and maybe if you just use the string for the range? It worked for me:

Please Login or Register  to view this content.

[matrixknow]

thanks adamben, it works.
I needed simply to use a string as your proposal !