**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.*