what is the "000" for? the tab numbers?

Yes.

ROW(INDIRECT("1:13"))

Returns an array as the numbers: 1, 2, 3...13

Putting that inside the TEXT function we can define a number format that
matches the name format of your sheets:

TEXT(ROW(INDIRECT("1:13")),"000")

Now that array looks like this: 001, 002, 003, ...013.

And the outer INDIRECT function finishes building the whole reference:

INDIRECT("'"&TEXT(ROW(INDIRECT("1:13")),"000")&"'! D33:D46*")

This becomes:

'001'!D33:D46
'002'!D33:D46
'003'!D33:D46
.....
'013'!D33:D46


--
Biff
Microsoft Excel MVP


"Chuck" wrote in message
ups.com...
hi again biff,


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

curious, what is the "000" for? the tab numbers?