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.