All solutions SUM Expert Solution – Excel SUM Problems

Excel - SUM Function Problem - Expert Solution

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

I need a formula to add values in different cells in a row with two different text conditions in the same row. for eg. I want the sum of a3,m3,aa3,am3 with text conditions in b3,c3,ab3,ac3. (The formulated values to be reflected at az3).
Solved by A. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/05/2018 - 08:39
Hi…Welcome to Got It Pro
Excelchat Expert 05/05/2018 - 08:39
Hi…Welcome to Got It Pro
User 05/05/2018 - 08:40
hi
Excelchat Expert 05/05/2018 - 08:40
please complete your example data.
Excelchat Expert 05/05/2018 - 08:41
and i will will help you with the formula
User 05/05/2018 - 08:42
I need the sum value if row 1 has the condition of 1 and str at g1 and row 1 has the condition of 2 and rcr at h2
User 05/05/2018 - 08:44
sum value of a1 and d1 if row 1 has the condition of 1 and str at g1 and row 1 has the condition of 2 and rcr at h1
Excelchat Expert 05/05/2018 - 08:44
so you want the sum in G1 and H1
User 05/05/2018 - 08:44
yes
Excelchat Expert 05/05/2018 - 08:45
if the condition is not met then?
Excelchat Expert 05/05/2018 - 08:47
please look at the formula in G1 and H1
Excelchat Expert 05/05/2018 - 08:47
is that what you are looking for?
User 05/05/2018 - 08:48
No at G1 I need 1200 and H1 I need 1400 since i require the condition of 1 and str at g1 and 2 and rcr at h1
Excelchat Expert 05/05/2018 - 08:50
but you said you want the sum of A1 and D1 in G1
User 05/05/2018 - 08:50
for easy understanding i have expanded the series now i need 2800 at l1 and 3200 at m1
Excelchat Expert 05/05/2018 - 08:51
you have already filled I1 with 1600
Excelchat Expert 05/05/2018 - 08:51
are you saying that should be a formula which should give a result of 2800?
User 05/05/2018 - 08:52
Let me explain in detail . I want the sum of A1,D1,G1,I1 at L1 with row condition of 1 and str and A1,D1,G1,I1 with row condition of 2 and rcr
Excelchat Expert 05/05/2018 - 08:56
and does this need to be in one row only?
User 05/05/2018 - 08:56
yes

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