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.