Discussion Locked

add multiple col. horizontal & vertical

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by ronypp

Will this do:

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

This discussion is closed to new replies.