Will define the range and try it. Thanks Bob.

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A1000="aa"),--(B1:B1000="bb"),--(C1:c1000="cc"))

SUMPRODUCT does not work on a complete column, just a defined range, and all
ranges must be the same size

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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