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.
