+ Reply to Thread
Results 1 to 3 of 3

conditional addition based on cell value

  1. #1
    Registered User
    Join Date
    05-01-2014
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    23

    conditional addition based on cell value

    Hello, I have a worksheet showing the values of pricing I have given to customers who will potentially order a product of mine. Naturally I have a cell showing the total of all quotes.

    The problem is, some people ask me for quotes which are only for budgetary purposes. In other words, they need to know the current pricing, but will not be ordering. I want to keep them on my sheet, but I do not want the value to be added to the overall quote total, because I know they will not be purchasing. Here is what my sheet looks like:

    SampleBudg.xlsx

    I would like for the SUM formula in B9 to ignore any prices in column C that have "Budgetary" listed beside them in column D.

    In this example, I would like the SUM formula in B9 to ignore the $60.00 in C7 because the value in D7 is Budgetary.

    Can you help?

    Thank you in advance.

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: conditional addition based on cell value

    will this help?

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    05-01-2014
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: conditional addition based on cell value

    Perfect! 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 row addition
    By tikrit in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-02-2012, 08:33 AM
  2. Conditional Addition
    By cellfservices in forum Excel General
    Replies: 3
    Last Post: 01-16-2010, 01:17 AM
  3. Conditional addition
    By matralab in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2009, 09:47 AM
  4. Excel 2007 : Conditional Addition
    By hayhursm in forum Excel General
    Replies: 5
    Last Post: 10-15-2008, 09:40 AM
  5. Conditional Addition
    By Andy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2005, 03:45 PM

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