Sum Values In Column If Condition Met In Another

  • Hi All,

    If anyone has a moment, I have a question that I think 'should' be easy to solve(?) except with my knowledge, seems to be a little more of a challenge:

    If possible, I would love for the answer to be a "formula" and not a macro, but if it must be a macro, then that's doable too:

    Basically, I would love a formula that would add all the numeric values in "Column A", as long as "Column B" in that same row="YES".


    4 YES
    6 YES
    7 NO
    9 YES

    would mean 4 + 6 + 9 = 19

    ....This will cover a variable amount of rows, but it will definitely be less than a few hundred.

    Thanks so much in advance!

  • Re: Sum Values In Column If Condition Met In Another

    Thanks Richard,

    That works perfectly! I had a feeling it may have been a short line, but didn't realize it was that short! :oops: Thank you so much for your help!!


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!