All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc