Sumif sum outcome as adding or sub column values

[drop05]

Hi have the below formula i am trying to edit the outcome,

=SUMIFS('Annual NEW'!$T:$T,'Annual NEW'!$B:$B,L$5,'Annual NEW'!$E:$E,$E143,'Annual NEW'!$H:$H,$F143)

i am trying to find a way that if those criteria's are met then the sum should be

Column M + N + O + P

and a similar case where

Column U + Column T - Column R

 

[Sufiyan97]

Hi have the below formula i am trying to edit the outcome,

=SUMIFS('Annual NEW'!$T:$T,'Annual NEW'!$B:$B,L$5,'Annual NEW'!$E:$E,$E143,'Annual NEW'!$H:$H,$F143)

i am trying to find a way that if those criteria's are met then the sum should be

Column M + N + O + P

Try

=SUMPRODUCT(('Annual NEW'!$B2:$B500=L$5)*('Annual NEW'!$E2:$E500=$E143)*('Annual NEW'!$H2:$H500=$F143)*M2:P500)