Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Sum Values In Column If Condition Met In Another

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

    Thanks so much in advance!
    CG

    Excel Video Tutorials / Excel Dashboards Reports


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


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. List N Top Values By Single Condition
    By pytelium in forum EXCEL HELP
    Replies: 4
    Last Post: October 30th, 2008, 19:33
  2. Highest To Lowest Values By Condition
    By squirtle in forum EXCEL HELP
    Replies: 3
    Last Post: February 7th, 2008, 03:04
  3. Search Xml Values Based On Condition
    By born2achieve in forum EXCEL HELP
    Replies: 2
    Last Post: January 11th, 2008, 22:50
  4. Sum Values In Column Based On Condition In Another
    By manikantah in forum EXCEL HELP
    Replies: 2
    Last Post: October 7th, 2007, 21:23
  5. Counting values if a condition occurs in another column
    By billybaxter in forum EXCEL HELP
    Replies: 11
    Last Post: December 13th, 2005, 19:08

Bookmarks

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