calculate totals
 

I have an attendance sheet with several columns(one for vacation taken, sick
days taken,personal days taken) is based on a rolling year. I have a
formula and that works fine, BUT Here comes the issue. Days taken have to
be shown in decending order. I tried adding rows and shifting rows down
but for abvious reasons that does not work.

IF I add the information at the bottom of the coulmn, sort it again in
descending order and recalculate the totals it works but that is very
manual and time consuming ( the attendance sheet has over 100 names)
Is there an easier way? pleeease

calculate totals
 

Not to sure how you have you spreadsheet, but could you not have two
columns that would add time there and time not there??

calculate totals
 

Thanks "damossison"Below is a sample of the columns I also have clums set
for Vacation days, personal days and other. Hope this helps clarify my
question
Personal Illness
Day Date Hours Rolling Actual

Mon 6/5/06 7.50 0.00 7.50
Mon 5/8/06 7.50 0.00 7.50
Fri 4/28/06 4.00 0.00 4.00
Thu 4/20/06 7.50 0.00 7.50
Thu 4/6/06 3.50 0.00 3.50
Fri 1/6/06 7.50 0.00 7.50
Thu 1/5/06 7.50 0.00 7.50
Tue 12/6/05 2.25 0.00 2.25
Thu 12/1/05 7.50 0.00 7.50
Tue 11/15/05 7.50 0.00 7.50
Mon 11/14/05 7.50 0.00 7.50
Mon 9/26/05 7.50 0.00 7.50
Mon 9/12/05 7.50 0.00 7.50
Tue 9/6/05 7.50 0.00 7.50
Mon 7/25/05 7.50 0.00 7.50
Wed 7/6/05 3.00 3.00 0.00
Thu 6/23/05 7.50 7.50 0.00
Wed 6/22/05 7.50 7.50 0.00
Tue 6/21/05 7.50 7.50 0.00
Fri 6/17/05 7.50 7.50 0.00
Mon 5/23/05 3.00 3.00 0.00
Mon 5/2/05 7.50 7.50 0.00
Mon 4/4/05 7.50 7.50 0.00
Fri 4/1/05 7.50 7.50 0.00
99.75
hours left 50.25
days left 6.70
check 150.00


"damorrison" wrote:

Not to sure how you have you spreadsheet, but could you not have two
columns that would add time there and time not there??

calculate totals
 

not exactly sure what you want to do, but you could use a formula like this,
with the top row (row 3 in this case) being blank, and insert the rows for
the new data at the top.

This formula assumes you want to add up the hours for the last 365 days.
Iput your data in rows 3:26, with blank rows at top and bottom - the dates
are in column B, and the hours in column C.

=SUMPRODUCT(($B$2:$B$27<=TODAY())*($B$2:$B$27=TOD AY()-365)*($C$2:$C$27))

"Marilyn" wrote:

Thanks "damossison"Below is a sample of the columns I also have clums set
for Vacation days, personal days and other. Hope this helps clarify my
question
Personal Illness
Day Date Hours Rolling Actual

Mon 6/5/06 7.50 0.00 7.50
Mon 5/8/06 7.50 0.00 7.50
Fri 4/28/06 4.00 0.00 4.00
Thu 4/20/06 7.50 0.00 7.50
Thu 4/6/06 3.50 0.00 3.50
Fri 1/6/06 7.50 0.00 7.50
Thu 1/5/06 7.50 0.00 7.50
Tue 12/6/05 2.25 0.00 2.25
Thu 12/1/05 7.50 0.00 7.50
Tue 11/15/05 7.50 0.00 7.50
Mon 11/14/05 7.50 0.00 7.50
Mon 9/26/05 7.50 0.00 7.50
Mon 9/12/05 7.50 0.00 7.50
Tue 9/6/05 7.50 0.00 7.50
Mon 7/25/05 7.50 0.00 7.50
Wed 7/6/05 3.00 3.00 0.00
Thu 6/23/05 7.50 7.50 0.00
Wed 6/22/05 7.50 7.50 0.00
Tue 6/21/05 7.50 7.50 0.00
Fri 6/17/05 7.50 7.50 0.00
Mon 5/23/05 3.00 3.00 0.00
Mon 5/2/05 7.50 7.50 0.00
Mon 4/4/05 7.50 7.50 0.00
Fri 4/1/05 7.50 7.50 0.00
99.75
hours left 50.25
days left 6.70
check 150.00


"damorrison" wrote:

Not to sure how you have you spreadsheet, but could you not have two
columns that would add time there and time not there??