I have a spreadsheet of data.
Column A contains "Group Names"
Column B has "the people within that group"
Columns C thru J contians the number of hours each individual has worked
Week 1, Week 2, Week 3, etc...

I have created filters on every column... If I filter on column A it will
provide me with those people who only work within that group in column B, and
their respecitve hours worked.

My question... I have a formula at the bottom of the spreadsheet that will
give me the total # of hours worked depending upon what I have the filter set
to. The formula is SUBTOTAL(1,L1:L1132). What I would like to do is create
another formula below this one which will hold the TOTAL GROUP HOURS
worked... even when I filter down to an individual person in Column B - so
that I can see the "PERCENTAGE" of hours an individual worked in relationship
to the group.

Any suggestions????