Formula

J

Juran

On the below formula.

On the first one I wrote ...="m*"... and I got 0 as a result
On the second one I wrote ...="may".. and I got the number I wanted.

=SUMPRODUCT(--($A$107:$A$130="m*"),--($B$107:$B$130=18),--($F$107:$F$130="asml"))

=SUMPRODUCT(--($A$107:$A$130="may"),--($B$107:$B$130=18),--($F$107:$F$130="asml"))

Is there are reason that "*" does not work in this formula but work in
other formulas that If (countif)?

Thank you.

Rubem
 
M

Miguel Zapico

The place where the * is located in your formula is a basic comparision
(a=b), nothing to do with any other builtin formula. Wildcards are not
recognized in that situation, and that is normally what you would expect.

Miguel.
 
P

Peo Sjoblom

To add to what Miguel said, if you want something somewhat similar to a
wildcard you can use

(LEFT($A$107:$A$130,1)="m")

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top