Quote:
Originally Posted by no_name
I have a cell which has the code
=INDIRECT("'" & Summary!A18 & "'!" & "A23") in it.
I want to use this value in a COUNTIFS
what should the syntax be?
Thanks in advance
|
You don't make it clear in your question exactly what you're trying to do.
Do you want to use the value that results from the INDIRECT formula above as the value to count in the COUNTIF, or to identify the range in which to count a value??
Explain more of what you're trying to do and an answer will be provided much quicker.
S.