+ Reply to Thread
Results 1 to 3 of 3

sum up column and exclude if variable

  1. 09-30-2016, 10:03 AM #1
    chubbychub
    chubbychub is offline
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    sum up column and exclude if variable

    hi, currently I have this formula in a cell:
    =SUMIF(F:F,">0")

    I want the formula to sum up column f, but if column c has "NC" I don't want to sum it up.
    Please help.
    Reply With QuoteRegister To Reply
  2. 09-30-2016, 10:08 AM #2
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: sum up column and exclude if variable

    Try:

    =SUMIFS(F:F,F:F,">0",C:C,"<>NC")
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 09-30-2016, 10:12 AM #3
    chubbychub
    chubbychub is offline
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    Re: sum up column and exclude if variable

    that works! thank you NBVC
    this forum is amazing.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA exclude column within range
    By syedmehdi in forum Excel General
    Replies: 2
    Last Post: 03-06-2015, 08:08 AM
  2. [SOLVED] How do I exclude data from 1 column using conditions from another column
    By Funky Gibbon in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-15-2013, 06:44 PM
  3. [SOLVED] Exclude column J from locking
    By var in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2012, 05:08 PM
  4. Excel formula Difference 2 dates,include w/e's,exclude hols,variable business hours
    By JammyDodger in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-07-2011, 06:26 AM
  5. average the numbers in a column but exclude some values based on other column data
    By MrZ113 in forum Excel General
    Replies: 8
    Last Post: 02-16-2011, 05:03 PM
  6. How to exclude column data
    By raym0nd in forum Excel General
    Replies: 5
    Last Post: 09-08-2010, 12:54 PM
  7. I want to sum a column and exclude those ending with cr
    By cbanks in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-05-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1