+ Reply to Thread
Results 1 to 3 of 3

Question: Conditional Formula including sum, blanks, and multiple cells

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Missouri, USA
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Question Question: Conditional Formula including sum, blanks, and multiple cells

    I am having trouble working through some conditional formulas. Any Help would be appreciated. I would be ok with using other cells for formulas if needed to provide the solution.

    Option A: If any of the cells in D10:D13 or E10:E13 are blank, I would like D14 & E14 to be blank also. If all of those cells contain a number, even if "0", then I would like each to return a specific answer. See the conditional formulas below.

    Option B: If all cells in D10:D13 & E10:E13 don't have a numerical value, then cell C6 should show a blank. If all of the cells have numerical values, then it should show the sum of D15+E15

    Excel question picture.JPG
    Attached Images Attached Images
    Last edited by unfmarine; 01-08-2015 at 12:45 PM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Question: Conditional Formula including sum, blanks, and multiple cells

    In D14
    =IF(COUNTBLANK(D10:D13),"",SUM(D10:D13))
    Copy across to E14

    In C6
    =IF(COUNTBLANK(D10:E13),"",SUM(D15:E15)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    01-08-2015
    Location
    Missouri, USA
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Thumbs up Re: Question: Conditional Formula including sum, blanks, and multiple cells

    ACE XL,

    That worked perfectly...Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting - No Blanks question
    By MarkyDee in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-21-2014, 05:12 AM
  2. Replies: 1
    Last Post: 10-24-2012, 01:21 PM
  3. Tricky formula question. including email
    By jeroenheki in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2012, 06:57 PM
  4. [SOLVED] Question re. conditional formatting cells with formula
    By kborgers in forum Excel General
    Replies: 5
    Last Post: 06-22-2012, 04:52 AM
  5. How do I sum multiple columns counting including blanks and dates
    By BK99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2005, 06:05 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1