INDIRECT function to count non blank cells on another worksheet

[ManCityPete]

I’m trying to count non-blank cells on another worksheet referenced using the INDIRECT function.

Oddly it’s returning the number of cells in the entire range, ie the whole column, and I don’t know why.

In L4 is the name of the worksheet I am wanting to count

My formulae is =COUNTA(INDIRECT(“‘“&L$4&”’!”&”A:A”)

This is returning 1048576 but I’m to dumb to figure out why?

Any help would be appreciated.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Did you copy/paste the formula direct from Excel to the board?

 

[ManCityPete]

Thank you for replying. Just your question re whether I'd coied the formula fixed it. When I looked, I'd done a subtraction to that formula that screwed it up. Like I said, dumb!

Thank you anyway

 

[Fluff]

Glad you sorted it & thanks for the feedback.