If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
YTD % over 12 accumulating figures
I have a spreadsheet listing out employees, e.g. as follows:
Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total YTD% A N Other 1 0 0 0.5 5 0 0 0 0 0 0 0 6.5 F Smith 0 0 0 0 0 0 0 0 0 0 0 0 0 M Brown 0 0 3 0 0 0 0 0 0 0 0 0 3 Days of Mth 20 20 22 19 21 20 20 21 22 21 22 21 249 I need to as an example total the days of month up to end of May (being 102 days) and subsequently in June (122 days) etc., to calculate the YTD % per person. Many thanks in advance for any help provided. |
#2
|
|||
|
|||
YTD % over 12 accumulating figures
I dont think I have understood correctly
Suppose you have the days of month in row 10. The below formula in Col B will give you the cummulative for Jan..Now copy/drag this formula to the right and that gives you the cummulative days.. =SUM($B$10:B10) -- Jacob (MVP - Excel) "Ellie" wrote: I have a spreadsheet listing out employees, e.g. as follows: Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total YTD% A N Other 1 0 0 0.5 5 0 0 0 0 0 0 0 6.5 F Smith 0 0 0 0 0 0 0 0 0 0 0 0 0 M Brown 0 0 3 0 0 0 0 0 0 0 0 0 3 Days of Mth 20 20 22 19 21 20 20 21 22 21 22 21 249 I need to as an example total the days of month up to end of May (being 102 days) and subsequently in June (122 days) etc., to calculate the YTD % per person. Many thanks in advance for any help provided. |
Thread Tools | |
Display Modes | |
|
|