Prev: Macro to build table
Next: prompting while typing
From: Ellie on 27 May 2010 15:59
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.

From: Jacob Skaria on 27 May 2010 18:03
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.
>
 | 
Pages: 1
Prev: Macro to build table
Next: prompting while typing