For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Robin W" wrote in message
...
FANTASTIC!!!!! Thanks so much! Can't believe that you just solved
literally
2 days of searching and searching for the help I needed!!!
--
Robin W


"TomPl" wrote:

You would need to adjust the ranges and the values in this formula to get
the
results you want:

=SUMPRODUCT(--(A3:A6<30),--(A3:A625),--(B3:B6=0))

Tom