COUNTIF MULTIPLE CRITERIA
Thanks will try it Ron.
"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
|