D
Delya
Hi,
I need a simple formula... seems very diffucult to get
In Sheet 1 I have employee names on horizontal line and a lot of numbers in
vertical line.
In Sheet2, i Have emloyee names on vertical line and in horisontal line i
want to set up formula in sheet2 so that it calcualtes total number for each
month for each name as per below sample:
Sheet1 John
Month days
January 5
january 3
january 4
February 10
March 6
TOtal 28
Sheet 2
JOhn January February March
12 10 6
or at least John and 28 days total.
I need a simple formula... seems very diffucult to get
In Sheet 1 I have employee names on horizontal line and a lot of numbers in
vertical line.
In Sheet2, i Have emloyee names on vertical line and in horisontal line i
want to set up formula in sheet2 so that it calcualtes total number for each
month for each name as per below sample:
Sheet1 John
Month days
January 5
january 3
january 4
February 10
March 6
TOtal 28
Sheet 2
JOhn January February March
12 10 6
or at least John and 28 days total.