+ Reply to Thread
Results 1 to 5 of 5

Sum If

  1. 01-18-2018, 03:15 AM #1
    Shilpa kanchan
    Shilpa kanchan is offline
    Registered User
    Join Date
    12-18-2011
    Location
    India
    MS-Off Ver
    excel2007
    Posts
    62

    Sum If

    Hai Friends

    In my attached sheet i want to calculate the month wise amount.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-18-2018, 03:19 AM #2
    kersplash
    kersplash is offline
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Sum If

    I solved it with a pivot table if that suits.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 01-18-2018, 03:20 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Sum If

    So use the SUMIFs() function?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 01-18-2018, 03:58 AM #4
    Shilpa kanchan
    Shilpa kanchan is offline
    Registered User
    Join Date
    12-18-2011
    Location
    India
    MS-Off Ver
    excel2007
    Posts
    62

    Re: Sum If

    I want to solve it in formula, not table or chart
    Reply With QuoteRegister To Reply
  5. 01-18-2018, 04:58 AM #5
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Sum If

    In D3, copied down: 
    Please Login or Register  to view this content.
    D3 can also be copied to G3 and down.
    Last edited by leelnich; 01-18-2018 at 05:02 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    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