Can I combine?

[spotsteven]

I use the following formula to calucate data with auto filters.. Can I combined them?


=SUMPRODUCT(SUBTOTAL(3,OFFSET($F$35:$F$10005,ROW($F$35:$F$10005)-ROW($F$35),0,1)),--($F$35:$F$10005=D9))

=SUMPRODUCT(SUBTOTAL(3,OFFSET($G$35:$G$10005,ROW($G$35:$G$10005)-ROW($G$35),0,1)),--($G$35:$G$10005=E9),$O$35:$O$10005)

=SUMPRODUCT(SUBTOTAL(3,OFFSET($E$35:$E$10005,ROW($E$35:$E$10005)-ROW($E$35),0,1)),--($E$35:$E$10005=F9),$O$35:$O$10005)

Thanks in advance!

 

[spotsteven]

Can it be done