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


--
Juran
------------------------------------------------------------------------
Juran's Profile: http://www.excelforum.com/member.php...o&userid=23592
View this thread: http://www.excelforum.com/showthread...hreadid=544021