Im getting 0 (zero). what do you mean adjust range reference? thanks

"Ron Coderre" wrote:

Try this:
=SUMPRODUCT(--(A1:A10="aa"),--(B1:B10="bb"),--(C1:C10="cc"))

Adjust range references to suit your situation

Does that help?

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


"will A" wrote:

To count if Col A=aa and Col B=bb and Col C=cc. Must meet all situation.
Thanks
will A