Should be the below for wildcards...

=SUMPRODUCT((A2:A100="name")*(C2:C100="sold")*(ISN UMBER(SEARCH({"NEW","UNDER"},S2:S100))))

If this post helps click Yes
---------------
Jacob Skaria


"Trev" wrote:

I need a formula that counts if column C = Sold, and column A = Name and
column S and be either New* or Under*

=COUNTIFS(C:C,"sold",A:A,"name")can equal Name or Under

Is this possible?
Thanks