COUNTIFS('Cycle 1'!$B$14:$B$1069, "Auto*", 'Cycle 1'!$J$14:$J$1069, "100%")
Does the range J14:J1069 contain numbers formatted as Percentage?
See if this does what you want...
=SUMPRODUCT(--(LEFT('Cycle 1'!$B$14:$B$1069,4)="Auto"),--('Cycle
1'!$J$14:$J$1069=1))
--
Biff
Microsoft Excel MVP
"Courtney" wrote in message
.. .
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