countifs

[Trev]

I am confused and my formula still does not work. Any help?

 

[T. Valko]

That comment was directed at Jacob.

Here's a small sample file that demonstrates this.

xTrev.xlsx 8kb

http://cjoint.com/?kkxj281z7M

 

[Jacob Skaria]

Oops. I havn't looked at this question for a while; and thought Trevs last
response is unattended..

PS: From the original query onwards; Trev is looking at ColS with wildcards;
which I dont think you have noticed...(until your last response..)

 

[Jacob Skaria]

Trev, are you able to sort out this; or do you have problems still?

=SUMPRODUCT(
--('Pending Sold'!A:A="name"),
--('Pending Sold'!C:C="sold"),
--('Pending Sold'!F:F>=1),
--('Pending Sold'!F:F<=150000),
--(ISNUMBER(SEARCH({"NEW","UNDER"},S:S))))

PS: As Biff mentioned refer the entire column only if really needed.

If this post helps click Yes