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

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

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.

Cheers!

2. 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. Originally Posted by NBVC
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. 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. Originally Posted by NBVC
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. Originally Posted by JMSisto
but it didn't work.
Why not?
See my attach

7. Originally Posted by navic
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. Originally Posted by JMSisto
It does work! I had a trailing space on my dashboard
NBVC note for you

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

#### Posting Permissions

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