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