Avg/date

[kkondrat1]

Date CycleTime

04/01/2004 8
04/01/2004 7
05/01/2004 17
06/01/2004 13
07/01/2004 10
07/01/2004 12
07/01/2004 18
07/01/2004 18
08/01/2004 14
08/01/2004 7

I need to write a formula that will return the average per month cycl
time:

the reult will return:

April: 7.5
May: 17
June: 13
July: 14.5
August: 10.5

any ideas

 

[Niek Otten]

From the menu: Data>Subtotals, in the Use function box, select Average

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Domenic]

=AVERAGE(IF((MONTH(A2:A11)=4)*(YEAR(A2:A11)=2004),B2:B11))

...entered using CONTROL+SHIFT+ENTER.

OR

List your dates in a column, for example Column D starting at D2, i
the following format...

January 2004
February 2004
etc.

Then, enter the following formula in E2 and copy down:

=AVERAGE(IF((MONTH($A$2:$A$11)=MONTH(D2))*(YEAR($A$2:$A$11)=YEAR(D2)),$B$2:$B$11))

...entered using CONTROL+SHIFT+ENTER.

Hope this helps