Try this:
A1: (some value)
A2: (some other value)
A3: =SUMPRODUCT(--(B1:B10=A1),--(C1:C10=A2))

Counts the combinations of Col_A=A1 and Col_B=A2.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Bill" wrote:

I am trying to set up a formula that will count the instances of specific
dates. Example: Only count the number of times that a cell in Column B
(B4=1) and a corresponding cell in Column C (C4=2) meet the required
parameters.

I have been trying to use the COUNTIF function but can not get it to work
with the AND function since the AND function does not seem to work well with
a range of data.

Any help would be appreciated.