Using an array formula you can get the counts that you need. Type the
following formula, modifying the ranges in columns C & D as needed:

=SUM(IF((C1:C34=2)+(D1:D34="New")=2,1,0))

But don't press the Enter key, press Ctrl + Alt + Enter to make the formula
an array.

Should you modify the formula you will need to press Ctrl + Alt + Enter
after the edit to retain teh array status of the formula
--
Kevin Backmann


"confused2007" wrote:

How do I write this statement (or another appropriate one) to count the
number of entries that meet two criteria? The data is contained in two
different columns.

Example - what is the # of entries that contain the number 2 in a specific
range in column C AND the word "new" in a specific range in column D.