Averaging every month

[omer123456]

Hi,

I have the following data......Column A is date & column B is Kilos.........I would like to see the monthly average

Solution: Jan rate was 1788, Feb rate was 1899...etc

Thanks

Date Run
1/2/2012 1771.6
1/3/2012 1192.7
1/4/2012 1516.5
1/5/2012 278.7
1/6/2012 819.4
1/7/2012 0.0
1/8/2012 519.5
1/9/2012 0.0
1/10/2012 1193.1
1/11/2012 1478.2
1/12/2012 1871.0
1/13/2012 1999.9
1/14/2012 1881.9
1/15/2012 1999.9
1/16/2012 1999.9
1/17/2012 1999.9
1/18/2012 2000.1
1/19/2012 1999.9
1/20/2012 2000.0
1/21/2012 1999.9
1/22/2012 1999.9
1/23/2012 2000.0
1/24/2012 2000.0
1/25/2012 1999.9
1/26/2012 1999.9
1/27/2012 1765.8
1/28/2012 1499.9
1/29/2012 1500.0
1/30/2012 1758.7
1/31/2012 1999.9
2/1/2012 1999.9
2/2/2012 1999.9
2/3/2012 2000.1
2/4/2012 1999.9
2/5/2012 1999.9
2/6/2012 1444.1
2/7/2012 1331.2
2/8/2012 1898.4
2/9/2012 2036.0
2/10/2012 1987.7
2/11/2012 2099.9
2/12/2012 2099.9
2/13/2012 2100.0
2/14/2012 2099.9
2/15/2012 2100.0
2/16/2012 2029.1
2/17/2012 2100.0
2/18/2012 2099.9
2/19/2012 2099.9
2/20/2012 2100.0
2/21/2012 2033.5
2/22/2012 1999.9
2/23/2012 1999.9
2/24/2012 1999.9
2/25/2012 1999.9
2/26/2012 1999.9
2/27/2012 2000.1
2/28/2012 2000.1
2/29/2012 1999.9
3/1/2012 2000.0
3/2/2012 1956.3
3/3/2012 1945.7

[Special-K]

Pivot Table is the way to go

[omer123456]

OK I am not familiar with Pivot tables.............Can someone propose a formula or do a pivot table and post it so I can see

Thanks for the help though

[FDibbins]

Make up a small take with dates, like below...

	D	E
2	1/1/2012	1568.203
3	2/1/2012	1988.234
4	3/1/2012	1967.333
5	4/1/2012
6	5/1/2012
7	6/1/2012
8	7/1/2012
9	8/1/2012
10	9/1/2012
11	10/1/2012
12	11/1/2012
13	12/1/2012

E2=IFERROR(AVERAGEIFS($B$2:$B$63,$A$2:$A$63,">="&D2,$A$2:$A$63,"<"&EDATE(D2,1)),"")
copied down

(Jan rate was 1788, Feb rate was 1899...etc...Jan was actually 1568.203)

[omer123456]

OK Thanks..... Yes you are right 1568 was the actual #.