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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Wildcard in Excel array formula 0
How can I use the * wildcard in an array formula 4
Countif across multiple sheets - sheet NAME issue? 5
sumif wildcard for text and numbers 2
wildcard in IF function 5
Sum with multiple conditions and wildcard 2
Excel How to add numbers in same cell? 2
Sum variable range of column entries in offset cell 2

Back
Top