+ Reply to Thread
Results 1 to 7 of 7

Sumif nesting in sumif

  1. 02-11-2013, 03:19 AM #1
    mdasifiqbal
    mdasifiqbal is offline
    Registered User
    Join Date
    02-09-2013
    Location
    kolkata
    MS-Off Ver
    Excel 2007
    Posts
    11

    Sumif nesting in sumif

    Dear Members

    SUMIF NESTING IS SUM IF is it possible if so kindly suggest the formula

    Regards

    Asif
    Reply With QuoteRegister To Reply
  2. 02-11-2013, 03:22 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Sumif nesting in sumif

    Would you like to explain a little more and even better to upload a small sample workbook?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 02-11-2013, 03:35 AM #3
    mdasifiqbal
    mdasifiqbal is offline
    Registered User
    Join Date
    02-09-2013
    Location
    kolkata
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Sumif nesting in sumif

    Dear Fortis

    Have attached one file, I have highlighted in Yellow the cells where i need the forluma with 3 Criteria, 1 Sales, 2. Month, 3.Product

    Regards

    Asif
    Attached Files Attached Files
    Last edited by mdasifiqbal; 02-11-2013 at 03:38 AM.
    Reply With QuoteRegister To Reply
  4. 02-11-2013, 03:38 AM #4
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Sumif nesting in sumif

    I don't see an attachment my dear friend
    Reply With QuoteRegister To Reply
  5. 02-11-2013, 03:40 AM #5
    mdasifiqbal
    mdasifiqbal is offline
    Registered User
    Join Date
    02-09-2013
    Location
    kolkata
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Sumif nesting in sumif

    Sorry has skipped but i Have attached now
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-11-2013, 03:45 AM #6
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Sumif nesting in sumif

    Use SUMIFS

    In D2
    Please Login or Register  to view this content.
    In E2
    Please Login or Register  to view this content.
    In F2
    Please Login or Register  to view this content.
    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  7. 02-11-2013, 03:52 AM #7
    mdasifiqbal
    mdasifiqbal is offline
    Registered User
    Join Date
    02-09-2013
    Location
    kolkata
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Sumif nesting in sumif

    Great It working

    Thanks A Lot
    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)

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