CODEWITHSUNDEEP
sumcellexcel-formula
user572844
user572844

Reputation:

Excel - sumifs - condition when cell contains string

I need little help with excel. I use SUMIF func. Here is my formula.

=SUMIFS(J:J;B:B;O4;G:G;"=ISTEXT(Intercall)")

I would like make a sum from values in J column, where:

for example value in column G is Intercall - Taiwan -> thi value contains string Intercall

Upvotes: 1

Views: 14517

Answers (2)

Sleette
Sleette

Reputation: 376

I'm not 100% sure what you're asking, but maybe this will help.

SUMIFS accepts wildcards in criteria. So you can use:

=SUMIFS(J:J;B:B;O4;G:G;="*Intercall*")

Upvotes: 4

JMax
JMax

Reputation: 26591

Seems like you are trying to make a multiple criteria SUMIF.

In your case, the formula could look like:

=SUMPRODUCT((J1:J22)*(B1:B22=$O$4)*(G1:G22="Intercall"))

I'm not sure i understood properly your last point (is the string the same for every cell?)

Upvotes: 0

Related Questions