Thread: COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
View Single Post
  #1  
Old April 19th, 2010, 09:27 PM posted to microsoft.public.excel.worksheet.functions
Courtney[_3_]
external usenet poster
  
Posts: 2
Default COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard"
Hi all,

I am trying to find a way to write the following formula in Excel 2003. I
have tried SUMPRODUCT but it does not seem to work when both criteria have
text values. I tried COUNTIF & COUNTIF but I think the wildcard * is
throwing off the result.

=COUNTIFS('Cycle 1'!$B$14:$B$1069, "Auto*", 'Cycle 1'!$J$14:$J$1069, "100%")


Please help!
Thank you!

url:http://www.ureader.com/gp/1042-1.aspx