Help Writing a formula

AmandaB

New member
Joined
May 28, 2014
Messages
1
Reaction score
0
Points
0
Hi, I need help to write this formula IF column C and Column H have the same value, then add the value of Column I to Column F and add the value of column J to column G
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Are you saying that if C2 = 2 and H2 = 2 and I2=11 and F2 = 23 you want to get 34 in F2. If so, that cannot be done by a formula, as you can't have a formula that references itself. It can be done by event code though.
 

vinod

New member
Joined
Jun 2, 2011
Messages
15
Reaction score
0
Points
0
Hi Amanda,

If I understood correctly your question, here is my solution.

=IF(C3=H3,SUM(F3:I3,G3:J3),0)

if C = H column condition achieved give me the result as sum of F to I col and G to J coluumn. if not give me result as 0

Let me know if it gives you the solution.

attached the solution for the same.
 

Attachments

  • Example_if.xlsx
    9.1 KB · Views: 4
Top