It works GREAT.
just had to change to:
=SUM(B1:B500) -SUMPRODUCT( --(A1:A500> 0),--(A1: A500<10000) ,B1:B500)
from:
=SUM(B1:B500) -SUMPRODUCT( --(A1:A500> 1),--(A1: A500<10000) ,B1:B500)
to make "1" a non-read criteria.

Just wished I'd waited until I got your eMail. I just spent the last few hours
manually editing all the formulas in B to read as zero if 1-10000 was in A. FUN
not

=IF(AND(A18>0,A18<10000),0,equation already in cell) and they were all
different equations and on two different sheets.

Thanks for the help. I like your way better. Might even change them all back
(I have a back up file and can just copy and paste the old data  back in) and use
your solution.