+ Reply to Thread
Results 1 to 3 of 3

Sumif Excluding Blank Cells

  1. #1
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Sumif Excluding Blank Cells

    Hello,

    I need a formula to sum up column D only where there are no blank cells in column F
    I attached a file for example with the formula in C12-C15 , but the formula does not work.

    Can you please assist?

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Sumif Excluding Blank Cells

    It's better to enter the expected results than a formula that 'doesn't work', that way we can see clearly what you want, not what you've tried.

    Try

    =SUMIFS($D$2:$D$7,$C$2:$C$7,$B12,$F$2:$F$7,">0")

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Sumif Excluding Blank Cells

    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. [SOLVED] Excluding blank cells from COUNTIF?
    By Pr0 in forum Excel General
    Replies: 6
    Last Post: 07-20-2018, 01:05 PM
  2. [SOLVED] Excluding blank cells
    By Yaznayo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-14-2014, 02:31 PM
  3. Replies: 2
    Last Post: 11-15-2012, 07:34 AM
  4. Excluding blank cells from a range of data
    By Consty1 in forum Excel General
    Replies: 5
    Last Post: 10-11-2012, 03:19 PM
  5. [SOLVED] Excluding zero or blank cells when averaging
    By JohnDear in forum Excel General
    Replies: 2
    Last Post: 08-30-2012, 03:05 PM
  6. Excel 2007 : Autofill Excluding Multiple Blank Cells
    By Ichigo in forum Excel General
    Replies: 4
    Last Post: 05-06-2010, 06:36 AM
  7. Excel 2007 : Excluding Blank Cells
    By pxoxyx in forum Excel General
    Replies: 0
    Last Post: 04-28-2010, 01:47 AM

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