Hi , Is there any way you can simplify the following formula....

I am specifically interested in knowing whether it is possible to make all these SUMIF statements into one.

=IF(O6="",0,$S$103-SUMIF($F$4:$F$18,N6,$L$4:$L$18)-SUMIF($G$4:$G$18,N6,$L$4:$L$18)-SUMIF($H$4:$H$18,N6,$L$4:$L$18)-SUMIF($I$4:$I$18,N6,$L$4:$L$18)-SUMIF($J$4:$J$18,N6,$L$4:$L$18)-SUMIF($K$4:$K$18,N6,$L$4:$L$18))


Some thing like =IF(O6="",0,$S$103- ONLY ONE SUMIF). Else each time I add a column I need to add a sumif which makes the formula unreadable.