You'll need to use a sumproduct()

=SUMPRODUCT(--(range="AB"),--(newrangeDATE(2005,7,1)))


"Julie" wrote:

hello - I would GREATLY appreciate anyones help here.

I am doing a countif(range, "=AB") however I want to in the next column do
the same countif(range, "=AB") and then countif(newrange, "07/01/2005)

I'm tryiing to count ab's in one column and then in the second count I need
to say ok out of the ab's I counted in the first formula how many are
07/01/2005)

Thank you again for anyones tips\formulas!!!! Julie