countifs

  • Thread starter Thread starter Trev
  • Start date Start date
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..)
 
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
 
Back
Top