Announcement

Collapse
No announcement yet.

Sum Values In Column If Condition Met In Another

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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".

    So...

    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!
    CG

  • #2
    Re: Adding Numeric Values In Column A, Only If Column B Is Yes

    Hi

    =SUMIF(B:B,"YES",A:A)

    Richard

    Comment


    • #3


      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! Thank you so much for your help!!

      CG

      Comment

      Working...
      X