FIRST MANY THANKS

i tried and adjust the formula (array)
it retruned #value!

Regards

"Pete_UK" wrote:

Try this array* formula:

=AVERAGE(IF(MONTH(A1:A100)=1,B1:B100))

where the 1 is for January. Adjust the ranges to suit your data.

* An array formula must be committed using the key combination of Ctrl-
Shift-Enter (CSE) rather than the usual <enter. If you do this
correctly then Excel will wrap curly braces { } around the formula
when viewed in the formula bar - do not type these yourself. If you
need to edit/amend the formula you must use CSE again.

If you want to copy the formula down and have it automatically adjust
for different months of the year, then you can do this:

=AVERAGE(IF(MONTH(A$1:A$100)=ROW(A1),B$1:B$100))

Again, this is an array formula.

Hope this helps.

Pete

On Apr 27, 10:17 am, George A. Jululian
wrote:
hi all
i need your help

i have a table with two column first one date second rate for 365 days
A B
07/03/2006 0.913

i need average rate for each month

if its January the average rate is so

.