Hi!

Let me ask you a question. Does the formula you posted below look anything
like what Peo and Bob have suggested?

You're not "listening" !!!

Put the names of your sheets in a range of cells:

H1 = M-DEBEAU
H2 = B-HUTSON
H3 = W-DEBEAU
...
H17 = WARD

=SUMPRODUCT(SUMIF(INDIRECT("'"&H1:H17&"'!D17:D38") ,103,INDIRECT("'"&H1:H17&"
'!M17:M38")))

Biff

"JJackson" wrote in message
...

I still couldnt get it to work. This is the actual formula off my sheet
maybe you can see the error I am missing.

=SUMPRODUCT(SUMIF(INDIRECT("'"&M-DEBEAU:B-HUTSON:W-DEBEAU:R-ELLER:N-CARASCO
JR:N-CARASCO
SR:B-COTTON:D-DECKER:L-GREEN:P-ROLAND:T-THOMPSON:E-GALLEGOS:M-GOINGS:M-ARAGON:E-CARASCO:L-MITCHELL:WARD&"'!D17:D38"),103,INDIRECT("'"&M-DEBEAU:B-HUTSON:W-DEBEAU:R-ELLER:N-CARASCO
JR:N-CARASCO SR:B-COTTON:D-DECKER:L-GREEN:P-ROLAND:T-THOMPSON:E-
GALLEGOS:M-GOINGS:M-ARAGON:E-CARASCO:L-MITCHELL:WARD&"'!M17:M38")))

Thanks again for all your help...


--
JJackson
------------------------------------------------------------------------
JJackson's Profile: http://www.hightechtalks.com/m598
View this thread: http://www.hightechtalks.com/t2317219