Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate PivotTable Item Totals Based On Cell Contents? | Excel Worksheet Functions | |||
How to dynamically calculate totals from data being exported | Excel Worksheet Functions | |||
How can I calculate weekly totals of daily data in Excel | Excel Worksheet Functions | |||
I need to input daily cost codes would exceli calculate my totals | Excel Worksheet Functions | |||
calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions |