BJ,

Using this function, gave me a response of Zero "0" and I'm sure that isn't
correct. Should I use the CTRL ALT ENTER?

Ang

"bj" wrote:

Countif does not work well with multiple criteria.
the sumproduct function would work better try
=sumproduct(--(a1:a100=1),--(b1:b100=2),--(c1:c100=3))

"Angi" wrote:

I'm trying to create a countif function with three criteria, but for the life
of me I can't figure out the nested function. For example, I want to countif
column A=1, and column b=2 and column c=3. Can anyone help me with this?

Thank you so much!