software

Hi, im trying to sum data based on data in another cell and need to
incorporate a wildcard character. My formula is

=SUM(IF($G$2:$G$52997=BA2,$M$2:$M$52997,0))

I need to use the asterix (*) wildcard with the cell BA2.

Is this possible ? Thanks, Marcel.

=SUMIF($G$2:$G$52997,quot;*quot;amp;BA2amp;quot;*quot;,$M$2:$M$52997)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Marcelquot; gt; wrote in message
...
gt; Hi, im trying to sum data based on data in another cell and need to
gt; incorporate a wildcard character. My formula is
gt;
gt; =SUM(IF($G$2:$G$52997=BA2,$M$2:$M$52997,0))
gt;
gt; I need to use the asterix (*) wildcard with the cell BA2.
gt;
gt; Is this possible ? Thanks, Marcel.