+ Reply to Thread
Results 1 to 3 of 3

Adding another condition to my sum if function

  1. #1
    Registered User
    Join Date
    09-25-2013
    Location
    myob,ok
    MS-Off Ver
    Excel 2007
    Posts
    63

    Adding another condition to my sum if function

    Hello,

    Below is my function.

    ="Profit $"&SUM(IF(Sold!D15:D8998<>"",IF(MONTH(Sold!D15:D8998)=A4,Sold!H15:H8998)))

    I would like to edit this function to also count profit only if Cell A15:A8998 in my Sold sheet has the words "Shipped". The text value Shipped is not a text value I entered, it is automatically written based on a Vlookup formula I created. Any help on how to get this working with my function above will be greatly appreciated.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Adding another condition to my sum if function

    Perhaps

    ="Profit $"&SUM(IF(Sold!D15:D8998<>"",IF(MONTH(Sold!D15:D8998)=A4,IF(Sold!A15:A8998="Shipped",Sold!H15:H8998))))

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

    Re: Adding another condition to my sum if function

    Try

    ="Profit $"&SUM(IF(Sold!D15:D8998<>"",IF(MONTH(Sold!D15:D8998)=A4,IF(Sold!A15:A8998="shipped",Sold!H15:H8998))))

    confirm with ctrl+Shift+Enter
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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. Adding 1 more condition to an IF function
    By seraphim666 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2013, 08:21 AM
  2. Adding an 'OR' condition to this code
    By adc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2011, 03:04 PM
  3. condition adding
    By choy96 in forum Excel General
    Replies: 8
    Last Post: 03-24-2010, 07:22 AM
  4. Adding with Condition
    By rizmomin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-29-2008, 06:32 PM
  5. adding part of a function on condition.
    By foxgguy2005 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-26-2005, 09:45 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