Problem with using the Value of a Cell as part of a COUNTIF Range

[ARGK]

Hi
Can someone tell my why this formula will not work please :

=COUNTIF(C5:ADDRESS(VLOOKUP(MONTH($S$1),$B$10:$B$21,1,FALSE)+9,MATCH(DAY(S1),$C$9:$AG$9,0)+2),"X")

I am trying to use the result of a formula in a cell as the range end (this changes regularly).
Thanks in anticipation.
Tony

[XOR LX]

Hi,

You need an INDIRECT in there:

=COUNTIF(C5:INDIRECT(ADDRESS(VLOOKUP(MONTH($S$1),$B$10:$B$21,1,FALSE)+9,MATCH(DAY(S1),$C$9:$AG$9,0)+2)),"X")

Regards

[ARGK]

Hi XOR LX
Many thanks for the prompt response. Why is it so easy when someone else looks at your issue .
Thanks again.
Tony

[XOR LX]

It's often the way, my friend!

You're welcome.