Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding cell values based on a percentage

    Hi Guys,
    In the attahced spreadsheet, what I am trying to automate is the addition of any cells in the area A2-C15 that comply with the criteria that their Probability is = or > than 50%. The total is to be in cell C20, formatted in green type. I'd be grateful if someone could suggest a solution.
    Cheers,
    DavidExample.xlsx

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi David

    see attached file.
    I changed the content of cell [B20] for the criteria definition.

    zeddy
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Jan 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Zeddy,
    Many thanks for the swift reply!
    Cheers,
    David

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi David

    You're welcome.
    Please ignore my typo ++ in the formula in cell [C20], it only needed the +, I was typing fast.
    And I should have said "Welcome to the Lounge" as it was your first posting here.
    So, welcome again.

    zeddy

Posting Permissions

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