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.

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.