Try something like this:

=SUMPRODUCT((B1:B30="New")*(J1:J30="Closed"))

Adjust range references to suit your situation.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"readystate" wrote in message
...
I have a spreadsheet where column B is a drop down box with two choices -
NEW
or EXISTING. I need to count the number of times that the word NEW
appears
in column B if column J is equal to specific criteria, ex, CLOSED. Please
help me with this formula. Thanks.