sum if wildcard
 

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.

sum if wildcard
 

=SUMIF($G$2:$G$52997,"*"&BA2&"*",$M$2:$M$52997)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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