SUMIF function

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

Dominique Feteau

My first column starts off like this

IL-Chicago
IL-Chicago
IL-Springfield
NY-New York
NY-Queens
NY

Second column goes
20
30
40
45
70
150

How can i set up the "criteria" part of the "sumif" function to pick up
anything that has "IL" in it and not be specific by saying "IL-Chicago",
"IL-Springfield".

niq
 
Dominique Feteau said:
My first column starts off like this

IL-Chicago
IL-Chicago
IL-Springfield
NY-New York
NY-Queens
NY

Second column goes
20
30
40
45
70
150

How can i set up the "criteria" part of the "sumif" function to pick up
anything that has "IL" in it and not be specific by saying "IL-Chicago",
"IL-Springfield".

niq
Click to expand...

Use a wildcard, like this:
=SUMIF(A1:A100,"IL*",B1:B100)
 
Back
Top