I am trying to get the syntax right on a SUMIFS formula (requires Excel 2007 or 2010) that uses an INDIRECT reference to other worksheets in the workbook. While I've used both formulas before, I guess I haven't used both together, and I can't seem to get it right. In the attached file, I am getting a #REF error trying to use this formula in Cell M7 of the Cumulative Sales Units sheet:
e Sales Units'!B7)
As can be seen, in cells M8:M33, the same type of formula works but when I try to convert it to the above so I can copy the formulas across the page, using the Sheet names in the range M6:BL6, I get the #REF error in M7.
I appreciate any insights.