# 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.

CG

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

Hi

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

Richard

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

CG

## Participate now!

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