Results 1 to 8 of 8

Thread: Need help with summarizing the data

  1. #1

    Need help with summarizing the data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I have this sample data that I need to present every day to leadership. Unfortunately, as I am not aware of how to sum it up at the bottom of the table, I am doing it manually. Could anyone please help me how to get this accomplished with formulas

    Attached is the data for your reference

    Regards,
    Ramat
    Attached Files Attached Files

  2. #2
    Hi All,

    Please help, I am spending whole lot of time to do this manually

  3. #3

    Post Solution

    [QUOTE=ramat;17753]Hi All,

    The solution to this is that u can apply formula for each cell like this in data given by you

    =SUMIFS(G:G,F:F,"R",B:B,"<>")

  4. #4
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Ramat,
    Plz find attachment. is it help you ?
    Attached Files Attached Files

  5. #5
    I have applied the formula to data attached by you in previous post.

  6. #6
    Thanks Sambit,

    But the values it should pick is from column G and not from B thru E. For example if I change the value from 973K to 500 K in cell G11, the table should reflect this accordingly. But currently it is not showing this. Could you please help to modify this?

  7. #7
    Hi Yasm,

    This is amazing. It is working, but can I ask for one more help please. Some times it so happens that some of "Y" items are not fully at risk which means that there might be a partial amount that is risk and the balance can be collected. So, have inserted another column next to it that denotes the difference between the total for that region - risk associated.

    Can you please help me to get the balance as in the excel that is attached now? Please help
    Attached Files Attached Files

  8. #8
    Excel 2010 with free PowerPivot and Power Query Add-In.
    Compatible with Office 2013 Pro Plus.
    For the contemplation of advanced users.
    http://www.mediafire.com/view/65ix9n.../03_21_15.xlsx

Posting Permissions

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