Forum Discussion
Solved
SUMPRODUCT ERROR
I am trying to count the number of entries that meet a given criterion across 141 worksheets. I first use =@INDEX(SheetNames,G3) to retrieve each sheet name where SheetNames is the range of sheet n...
The formula syntax is correct, and it returns the correct result in a small test workbook that I created.
Make sure that EVERY cell in H5:H145 contains a valid worksheet name. If there is only one discrepancy, the formula will return #REF!
The formula syntax is correct, and it returns the correct result in a small test workbook that I created.
Make sure that EVERY cell in H5:H145 contains a valid worksheet name. If there is only one discrepancy, the formula will return #REF!