Formula
 

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

Formula
 

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.

"Juran" wrote:


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

Formula
 

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


"Miguel Zapico" wrote in message
...
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.

"Juran" wrote:


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