Hi!

Here's one way:

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"A","B","C","D","E "}&"'!D9:D1988"),F16,INDIRECT("'"&{"A","B","C","D" ,"E"}&"'!G9:G1988")))

Biff

"vicvega" wrote in message
...
I was trying to search several different sheets pull out some data that
might
or might not be in all of the sheets and have it summed at the moment I am
using combo of Vlookups such as:

=((VLOOKUP(F16,A!$D$9:$J$1988,4,FALSE))+
(VLOOKUP(F16,B!$D$9:$J$1988,4,FALSE))+
(VLOOKUP(F16,'C'!$D$9:$J$1988,4,FALSE))+
(VLOOKUP(F16,D!$D$9:$J$1988,4,FALSE))+
(VLOOKUP(F16,E!$D$9:$J$1988,4,FALSE)))


Is there a way to get it to work using SUMIF I tried using sumif with
using
AND in some of the arguments of the function with no luck,, any ideas
would
be appreciated