EXCEL - IF multiple strings in a range of cells

Question

Server Type      Count
Enterprise        3
Standard          24
Enterprise Core   6

In Excel, I am looking for to check if server type (A2-A5) contains both 'Enterprise' and 'Enterprise Core' or just 'Enterprise'. If it contains both, then add the two numbers together, otherwise, just display the number for 'Enterprise'.

What if it contains "Enterprise Core" but not "Enterprise"?

D Stanley
– D Stanley

2015-04-14 16:02:39 +00:00
Commented Apr 14, 2015 at 16:02 — D Stanley
– D Stanley, Commented Apr 14, 2015 at 16:02

Ditto · Accepted Answer · 2015-04-14 15:43:25Z

1

Perhaps just this:

=SUMIF(A:A,"Enterprise",B:B)+SUMIF(A:A,"Enterprise Core",B:B)

If it doesn't have both .. then it'll only find one to add ..

answered Apr 14, 2015 at 15:43

Ditto

3,3693 gold badges16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CactusCake · Accepted Answer · 2015-04-14 15:43:34Z

1

=SUMIF(A2:A5,"Enterprise*",B2:B5)

You can use the asterisk as a wildcard in sumif & countif.

answered Apr 14, 2015 at 15:43

CactusCake

1,0113 gold badges14 silver badges32 bronze badges

1 Comment

Ditto Over a year ago

re: Asterisk: Good point, I keep forgetting about that :) lol

Collectives™ on Stack Overflow

EXCEL - IF multiple strings in a range of cells

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related