hi biff,

i also tried yours

=SUMPRODUCT(SUMIF(INDIRECT("'"&TEXT(ROW(INDIRECT(" 1:13")),"000")&"'!
D33:D46*"),C5,INDIRECT("'"&TEXT(ROW(INDIRECT("1:13 ")),"000")&"'!
K33:K46")))

but getting the same error .. #REF .. invalid cell reference