The workbook has 23 worksheets, 1:23, where data is entered. Column B in each worksheet from B10:B133 is a named range called Received. When an item is received the receipt date is entered in column B. In that same workbook is a worksheet with formulas to count various totals for the month. I have not been able to write the below formula properly to count all cells with a date in the named range Received. The various ways I have written the formula have resulted in either a #NAME? or #REF! error. I have reviewed various sites regarding using this formula and I believe I am not placing a " or & correctly in the formula.
The formula is =SUMPRODUCT(COUNTIF(INDIRECT('1:23'!Received),">1"))
Any help you can provide will be greatly appreciated.
Thank you.
Bookmarks