General discussion

  • Creator
    Topic
  • #2285031

    add multiple col. horizontal & vertical

    Locked

    by samantha_b_titus ·

    currently I been using this formula
    =sumif(D6:D105,F124,E6:E105)
    However I want to add additional column and row ranges to my formula e.g.
    (F6:F105,F124,G6:G105) AND (H6:H105,F124,I6:I105)
    its the same formulas but how do intergrate it into one formula

All Comments

  • Author
    Replies
    • #3366284

      Reply To: add multiple col. horizontal & vertical

      by ronypp ·

      In reply to add multiple col. horizontal & vertical

      Will this do:

      =SUMIF(D6:D105,F124,E6:E105)+SUMIF(F6:F105,F124,G6:G105)+SUMIF(H6:H105,F124,I6:I105)

Viewing 0 reply threads