Works ok for me.

When I copied your posted formula and pasted it I got the general formula
error message: The formula you typed contains an error....

It highlighted this portion of the formula:

{"new";"under"}))

I just backspaced that out and retyped and it worked.

--
Biff
Microsoft Excel MVP


"Trev" wrote in message
...
I am trying to get this to draw from another sheet and keep getting an
error.
any ideas?


=SUM(COUNTIFS('Pending Sold'!A:A,"name",'Pending
Sold'!C:C,"sold",'Pending Sold'!S:S,{"new";"under'}))

"T. Valko" wrote:

Ooops!

Used the wrong range for that last criteria. Should be:

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


--
Biff
Microsoft Excel MVP


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