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.