Results 1 to 4 of 4

Thread: Help in SUMIF Formula

  1. #1
    Junior Member
    Join Date
    Sep 2012
    Posts
    5
    Rep Power
    0

    Help in SUMIF Formula

    Hi to All,

    I need your help on how to create a SUMIF Formula in Column I, please find attached Excel File. The result should look like in Column J:

    Many thanks.

    Regards,

    Aryan
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,106
    Rep Power
    10
    If you layout the data in a structured format, then a Pivot table would do the trick for you.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Sep 2012
    Posts
    5
    Rep Power
    0
    Hi Admin,

    I need to keep the format of the table for reporting purposes. However, if that will be possible for the Pivot Table to keep the same format, will you be able to help and assist me on how to do it using Pivot Table.

    Many thanks in advance!

    Regards,
    Aryan

  4. #4
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,106
    Rep Power
    10
    Unfortunately, the current format doesn't help to create the pivot.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. SUMIF with dates
    By aysam in forum Excel Help
    Replies: 1
    Last Post: 06-12-2017, 08:54 AM
  2. SUMIF COUNTIF To Look For More Than One Keyword
    By william516 in forum Excel Help
    Replies: 1
    Last Post: 08-06-2013, 12:33 AM
  3. Replies: 5
    Last Post: 04-07-2013, 05:41 PM
  4. Help with a Vlookup and SUMIF
    By Lucero in forum Excel Help
    Replies: 4
    Last Post: 07-24-2012, 05:33 AM
  5. Update data from closed workbook with sumif formula
    By leopaulc in forum Excel Help
    Replies: 4
    Last Post: 11-02-2011, 03:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •