try
=sumproduct((a2:a200=1)*(b2:b200=2)*(c2:c200=3))

--
Don Guillett
SalesAid Software

"Angi" wrote in message
...
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!