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.