sum if wildcard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marcel - 30 Apr 2006 11:09 GMT

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.

Reply to this Message

Bob Phillips - 30 Apr 2006 11:25 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi, im trying to sum data based on data in another cell and need to
> incorporate a wildcard character. My formula is
[quoted text clipped - 4 lines]
>
> Is this possible ? Thanks, Marcel.

Reply to this Message