=SUMPRODUCT(($A$2:$A$10="0233")*($B$2:$B$101000)* ($B$2:$B$10<2000))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brigitte" wrote in
message ...

Thanks. I can't believe I overlooked my ranges. I had them set for a
single cell rather than the full column.

One more thing....
I also need a count of the amounts that make up the total matching the
same criteria. Ideas?


--
Brigitte
------------------------------------------------------------------------
Brigitte's Profile:
http://www.excelforum.com/member.php...o&userid=32782
View this thread: http://www.excelforum.com/showthread...hreadid=548604