Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Thread: Sum Values In Column If Condition Met In Another

1. Member
Join Date
16th October 2007
Posts
20

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

Excel Video Tutorials / Excel Dashboards Reports

2. Banned
Join Date
18th September 2005
Location
Hampshire, UK
Posts
1,278

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

Hi

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

Richard

Excel Video Tutorials / Excel Dashboards Reports

3. Member
Join Date
16th October 2007
Posts
20

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

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno