[b]calculating Month Average For Exch Rates From Data Array

[StanUkr]

Hello, All,

need Yr help in formula creating. We have exchange rate calendar (USD
to Ukranian Hryvna) by every banking day in the year. Data organized as
following: col A - dates DD/MM/YYYY, col B - appropriate exchange rate,
for instanse - 5,05. I need to have in col C average month exchange
rate. So do i need to recognize that date belongs to the same month in
the same year and then to include appropriate rate to array for
calculating an average? that's my idea... Please comment

thanx in advance

 

[Bob Phillips]

=AVERAGE(IF((MONTH($A$1:$A$366)=MONTH(A1))*($A$1:$A$366<>""),$B$1:$B$366))

this is an array formula, so commit with Ctrl-Shift-Enter