enter image description hereI'm trying to sum all data in column E, where the row has a particular value in column D (in this instance '-2').

I have tried the below formula with no joy.


I've attached a screenshot for reference.

Can anyone help me?

1 Answer 1


Your data in Column D appears to be numeric in type. However, your formula is instructing FILTER to look for a string type, since you've enclosed the -2 in quotation marks. Try simply removing the quotation marks from before and after -2, after which FILTER will start looking for the true numeric value of negative two.

  • Success, thanks! Mar 18, 2021 at 6:36
  • Great. If you would, please take a moment to mark the solution as "Best Answer." This will indicate to other contributors at a glance that the issue has been resolved, as well as allowing future site visitors to more easily find the solution.
    – Erik Tyler
    Mar 18, 2021 at 15:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.