SUMIF function

[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

 

[Paul]

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

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

 

[Dominique Feteau]

Worked like a charm.

Thanx
Niq

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