Results 1 to 8 of 8

Thread: SUMIF? Need to extract and sum data from pivot to another sheet.

  1. #1

    SUMIF? Need to extract and sum data from pivot to another sheet.



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

    Hello!

    Need some help with the attached file. Looking to extrapolate and sum from NEWPremBnd, based on the source, to the dashboard for Good A and Good B.TEST.xlsx


    Tried a SUMIF -- no luck.

    Any advice is appreciated.

    Cheers!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Can you please be more detailed about the logic you are seeking? What exactly is supposed to be added together and according to what logic?


  3. #3
    Quote Originally Posted by NBVC View Post
    Can you please be more detailed about the logic you are seeking? What exactly is supposed to be added together and according to what logic?
    I am looking for a formula that will extract and sum all of the premiums associated with a particular producer.

    For example:
    tally all of Angelo's premiums in the Goods A table into the dashboard (into 'Dashboard' I14)
    and
    tally all of Angelo's premiums in the Goods B table into the dashboard (into 'Dashboard' J14)

    These two totals will ultimately comprise the total in H14.



    As you can see I currently am drawing both Goods A+B totals from Angelo's sheet, but would like to indicate the individual totals on the Dashboard as well.


    I hope I am making sense! Thank you for your response!!!

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    In I14 try:

    =SUMIF(INDEX(Table1,0,1),F14,INDEX(Table1,0,10))

    in J14 try:

    =SUMIF(INDEX(Table5,0,1),F14,INDEX(Table5,0,10))

    copied down.

    Note that your names in column B of Good A and Good B have a trailing space. Please remove them for your results to work. (CTRL+H, Replace a space with nothing).


  5. #5
    Quote Originally Posted by NBVC View Post
    In I14 try:

    =SUMIF(INDEX(Table1,0,1),F14,INDEX(Table1,0,10))

    in J14 try:

    =SUMIF(INDEX(Table5,0,1),F14,INDEX(Table5,0,10))

    copied down.

    Note that your names in column B of Good A and Good B have a trailing space. Please remove them for your results to work. (CTRL+H, Replace a space with nothing).

    Thanks NBVC, but it didn't work. Back to the drawing board.

  6. #6
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by JMSisto View Post
    but it didn't work.
    Why not?
    See my attach
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  7. #7
    Quote Originally Posted by navic View Post
    Why not?
    See my attach
    It does work! I had a trailing space on my dashboard as well.


    Thank you all so much. This board and its members are incredible!

  8. #8
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by JMSisto View Post
    It does work! I had a trailing space on my dashboard
    NBVC note for you

    Quote Originally Posted by NBVC
    Note that your names in column B of Good A and Good B have a trailing space
    It is important that you solve
    regards
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

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