sum if wildcard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,"*"&BA2&"*",$M$2:$M$52997)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top