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