Thread: sum if wildcard
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Marcel
 
Posts: n/a
Default 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.