Prev: Repeat the macro using different ranges
Next: SUMPRODUCT Returning 0 or wrong totals
From: Delya on 5 Mar 2010 08:23
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.
From: Teethless mama on 5 Mar 2010 08:28
Take a look SUMIF function in help menu or use PIVOT table


"Delya" wrote:

> 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.
 | 
Pages: 1
Prev: Repeat the macro using different ranges
Next: SUMPRODUCT Returning 0 or wrong totals