=SUMIFS(L19:L678, J19:J678, ">TEXT", K19:K678, "TEXT")
= 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?
是公式，我希望它寻找> TEXT但它认为我说的比文字更重要，我该如何解决这个问题？
2 个解决方案
#1
1
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:
如果你有A> TEXT，这将是总和。否则，您可以尝试：
=SUMPRODUCT((J19:J678=">TEXT")*(K19:K678="TEXT")*(L19:L678))
#2
6
Try this version with an additional "="
试试这个版本附加“=”
=SUMIFS(L19:L678, J19:J678, "=>TEXT", K19:K678, "TEXT")
= SUMIFS（L19：L678，J19：J678，“=> TEXT”，K19：K678，“TEXT”）
#1
1
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:
如果你有A> TEXT，这将是总和。否则，您可以尝试：
=SUMPRODUCT((J19:J678=">TEXT")*(K19:K678="TEXT")*(L19:L678))
#2
6
Try this version with an additional "="
试试这个版本附加“=”
=SUMIFS(L19:L678, J19:J678, "=>TEXT", K19:K678, "TEXT")
= SUMIFS（L19：L678，J19：J678，“=> TEXT”，K19：K678，“TEXT”）