Menu

Subtotals & Filters

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Don Guillett

Posts: n/a

Default

have a look in HELP index for SUMIF

--
Don Guillett
SalesAid Software

"BAM718" wrote in message
...
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????

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with nested subtotals, placing secondary subtotals BELOW .	Dawn Cameron	Excel Discussion (Misc queries)	1	June 3rd 05 10:13 PM
Excel gets subtotals out of order using multiple sorts and subtot.	jeffl	Excel Discussion (Misc queries)	1	March 29th 05 01:35 AM
Subtotals	Joan	Excel Discussion (Misc queries)	1	March 2nd 05 10:33 PM
Subtotals Problem when Filtering	Brenda Rueter	Excel Discussion (Misc queries)	2	February 15th 05 09:05 PM
why are nested subtotals coming out below outer subtotals?	Hendy	Excel Worksheet Functions	2	January 18th 05 08:09 PM

All times are GMT +1. The time now is 01:36 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement