One way:

=SUM(COUNTIFS(A2:A10,"name",C2:C10,"sold",D2:D10,{ "new";"under"}))

--
Biff
Microsoft Excel MVP


"Trev" wrote in message
...
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