Formula Simplification

[nanocrazy]

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.

[teylyn]

maybe

=if(o6="",0,$s$103-sumproduct(($f$4:$k$18=n6)*$l$4:$l$18))

[nanocrazy]

Thanks for the quick help mate... Your suggestion worked...