Subtotal with Sumif???

Hi all,

I have a weird one here - I'm trying to subtotal and sum Rows B2:E2 through B5:E5 off of whats viewable in the auto filter.

The subtotal is from columns Y,Z,AA,AB.

Kind of confusing but if I select a category in the auto filter Row 8 I want to see the subtotal put into the approriate 2010,2011,2012, etc.

see attached