spotsteven
Board Regular
- Joined
- Jul 14, 2005
- Messages
- 102
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!
=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!