link 2 formula

[sara90]

how to combine this 2

=SUBTOTAL(9,X4:X192)
=SUMIFS(X$4:X$192,$U$4:$U$192,"737")+SUMIFS(X$4:X$192,$U$4:$U$192,"732")+SUMIFS(X$4:X$192,$U$4:$U$192,"747")

need your help

 

[Chrisdontm]

Have you tried adding them together?;


=SUMIFS(X$4:X$192,$U$4:$U$192,"737")+SUMIFS(X$4:X$192,$U$4:$U$192,"732")+SUMIFS(X$4:X$192,$U$4:$U$192,"747")+SUBTOTAL(9,X4:X192)