Results 1 to 3 of 3

Thread: Help Writing a formula

  1. #1

    Help Writing a formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    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.

  3. #3
    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •