Forum Discussion
SUMPRODUCT ERROR
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!
Thank you. When I changed the value in H43 manually, everything worked. What I found is that the lrvel command is returning an error. It doesn't seem to find the range SheetNames that is supposed to be a "range" across the sheet names for all the worksheets. How do I create the appropriate range that references all the worksheet names?
If the definition of SheetNames is using GET.WORKBOOK, then you have to be sure that Excel 4.0 Macros are enabled for it to work.
This page describes how to ensure they are enabled in your workbook.
How is SheetNames defined?
