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