CODEWITHSUNDEEP
excel
user1524116
user1524116

Reputation: 75

Excel thinks that > is an operator, i want it as a string

=SUMIFS(L19:L678, J19:J678, ">TEXT", K19:K678, "TEXT")

Is the formula and I want it to look for >TEXT but it thinks I am saying greater than text, how do I get around this?

Upvotes: 3

Views: 148

Answers (2)

barry houdini
barry houdini

Reputation: 46371

Try this version with an additional "="

=SUMIFS(L19:L678, J19:J678, "=>TEXT", K19:K678, "TEXT")

Upvotes: 6

Jerry
Jerry

Reputation: 71578

Well, you can perhaps use something like that:

=SUMIFS(L19:L678, J19:J678, "*>TEXT", K19:K678, "TEXT")

Though this will sum if you have A>TEXT as well. Otherwise, you might try:

=SUMPRODUCT((J19:J678=">TEXT")*(K19:K678="TEXT")*(L19:L678))

Upvotes: 1

Related Questions