Excel - SUM Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

L25 to L30 of select in sum A1 to A50 of sum
Solved by K. U. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/05/2018 - 05:01
hi, welcome to got it pro!
Excelchat Expert 04/05/2018 - 05:02
If i understand correct, you want to do sum based o certain conditions
User 04/05/2018 - 05:03
sir meri sheet me select karne par total nhi hota vo kaise hota hai
Excelchat Expert 04/05/2018 - 05:03
HI, Could you type english please?
Excelchat Expert 04/05/2018 - 05:03
We are not be able to serve non english type excel related quesitons
Excelchat Expert 04/05/2018 - 05:04
IF you can show me some examples, then I'm nore than happy to assist you
User 04/05/2018 - 05:05
two column select of total
Excelchat Expert 04/05/2018 - 05:05
ok
Excelchat Expert 04/05/2018 - 05:06
So you are trying to sum based on 2 columns?
User 04/05/2018 - 05:06
yes
Excelchat Expert 04/05/2018 - 05:07
=sumif(A1:A4,"=2",B1:B4)
Excelchat Expert 04/05/2018 - 05:07
please look at the sample i created here based on the value on column A and B
User 04/05/2018 - 05:08
sir select column
Excelchat Expert 04/05/2018 - 05:09
in this example, you want to select column B based on col A?
Excelchat Expert 04/05/2018 - 05:10
If that is the case then here is the answer
User 04/05/2018 - 05:10
yes
User 04/05/2018 - 05:10
but
User 04/05/2018 - 05:11
if three column select of total no formula
Excelchat Expert 04/05/2018 - 05:12
Not sure what you mean
Excelchat Expert 04/05/2018 - 05:12
Can you show me a example?
User 04/05/2018 - 05:12
look in excel sheet
Excelchat Expert 04/05/2018 - 05:14
In this case, then you can use vlookup to find corresponding value

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.