Try this Jones

=SUMPRODUCT((J1:J10<1)*(B1:B103))


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jones" wrote in message ...
I need to count the number of entries in column B only if column J does not
equal "1" AND column B is 3.

Not looking for a "sum" or to "multiply", I simply need a count of the
number of entries in column B that match these two criteria.

I have tried combining functions through IF and COUNTIF, but have not been
successful. Any ideas? Thanks :)