**Question description:**

*This user has given permission to use the problem statement for this blog.*

if cells a1:a10 in sheet1 = cell a1 in sheet 2. Then how do I sum(b1:10) (but only the cells where a1:a10 in sheet1 = a1 in sheet 2) in sheet 1, to b1 in sheet 2

Solved by G. Y. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
27/01/2018 - 11:50

Hello! Welcome to Got It Pro-Excel.

User
27/01/2018 - 11:50

hey

Excelchat Expert
27/01/2018 - 11:51

Yes, How may I holp you with your formula?

Excelchat Expert
27/01/2018 - 11:52

You may share some part of information or any file you have for us to create the formula for you

User
27/01/2018 - 11:54

file>open goes to blank box, is it just lagging?

Excelchat Expert
27/01/2018 - 11:54

I think so

Excelchat Expert
27/01/2018 - 11:55

If you don't mine, you may share a google link for us to work on

User
27/01/2018 - 11:55

how do i take an existing spreadsheet and turn it into a google link?

Excelchat Expert
27/01/2018 - 11:55

Or copy+paste the sheet in our Document preview

Excelchat Expert
27/01/2018 - 11:56

Alright, click the "Share" button found at the upper right corner of your spreadsheet

Excelchat Expert
27/01/2018 - 11:57

Then, click the "Get shareable Link" at the pop up window

Excelchat Expert
27/01/2018 - 11:58

Change the settings into "can edit" then copy the link

User
28/01/2018 - 12:00

i have the formula in the previewer now

Excelchat Expert
28/01/2018 - 12:01

So, which cell do you want us to revise the formula?

Excelchat Expert
28/01/2018 - 12:02

Are you referring with your G2 formula at "Main pieces" tab?

User
28/01/2018 - 12:03

trying to make it so g2 in main pieces is the sum of all the P column in sub assembly where the value in e2 main pieces matches the value in the c column of sub assembly

Excelchat Expert
28/01/2018 - 12:04

Alright, please hold on. I will revise your formula

User
28/01/2018 - 12:12

I have to go, but I really need the formula if you can revise it sucseccfully could you possibly email a screen shot to matt@impactind.ca?

User
28/01/2018 - 12:13

ill leave the browser open

Excelchat Expert
28/01/2018 - 12:13

Oh, sure I will.

User
28/01/2018 - 12:13

Thanks so very much, I couldn't figure this one out

Excelchat Expert
28/01/2018 - 12:13

Thanks anyway, I assure you to email the result with you through our support team

Excelchat Expert
28/01/2018 - 12:14

This is the formula

Excelchat Expert
28/01/2018 - 12:14

=SUMIF('Sub Assembly'!C8, E5,'Sub Assembly'!P8:P258)

Excelchat Expert
28/01/2018 - 12:14

Just trying to check your E format and C format if they are the same to match the values

Excelchat Expert
28/01/2018 - 12:16

By the way, can we use another formula aside from using sumif?

Excelchat Expert
28/01/2018 - 12:18

The formula is now created, please take a look if you're still there

Excelchat Expert
28/01/2018 - 12:19

So, the formula looks like this

Excelchat Expert
28/01/2018 - 12:19

=IF('Sub Assembly'!C8=E2,sum('Sub Assembly'!P8:P258),0)

Excelchat Expert
28/01/2018 - 12:23

Also the formula looks like this

Excelchat Expert
28/01/2018 - 12:23

=IF('Sub Assembly'!C8=E2,sum('Sub Assembly'!P:P),0)

Excelchat Expert
28/01/2018 - 12:26

Still, I'm going to share with you this file

Excelchat Expert
28/01/2018 - 12:27

https://docs.google.com/spreadsheets/d/1jteudzosmlDr9fi_LnnrGIwRN23bMNYDbTaT4rzx1zM/edit?usp=sharing

Excelchat Expert
28/01/2018 - 12:28

Simply, click the above link and download for your copy under File Menu>>Download as>>Microsoft Excel(xsls)

Excelchat Expert
28/01/2018 - 12:29

Well, thank you for coming at Got It Pro-Excel!

Excelchat Expert
28/01/2018 - 12:29

Have a good day ahead!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*