Forum Discussion
Solved
Counta/CountIF autopopulate range from different sheet, where the sheet name may change
Hello, I don't know if this is possible, I have a very unique situation. We use Excel for our test cases, usually multiple sheets in one file. The main sheet is a summary results page, where we sum...
- Try this formula in G2, and copy down rows:
=COUNTIF(INDIRECT(A2&”!M1:M300”),
“N/A”)
Try this formula in G2, and copy down rows:
=COUNTIF(INDIRECT(A2&”!M1:M300”),
“N/A”)
=COUNTIF(INDIRECT(A2&”!M1:M300”),
“N/A”)
That worked!! For some reason it didn't like the formatting from here, but when I typed it into my formula your recipe worked! thanks so much!!
You're very much welcome!