can you use address function to make range limits??

[Barnapkin]

I need to make a countif function search using a range defined by other functions.
When run individually I can use the address function return the following in a cell:
Address(F3,F4,,,'Sheet1') returns Sheet1!$G$162
Address(G3,G4) returns $R$162

When I try to make a range from these I try:
Countif(Address(F3,F4,,,'Sheet1')&":"&Address(G3,G4),"> 0")
I get an error.

How does countif accept a range from a calculated range?

Thank you,

john

[Andrew-R]

Yes, if you wrap it inside an INDIRECT statement:

=COUNTIF(INDIRECT(ADDRESS(F3,F4,,,'Sheet1') & ":" & ADDRESS(G3,G4)),">0")

[Barnapkin]

THANK YOU VERY MUCH!!

Everything worked.