Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"

=AVERAGE(IF(TEXT(A1:A10,"mmmyyyy")="Jan2006",B1:B1 0))

--
Jacob (MVP - Excel)


"George A. Jululian" wrote:

Hi,

Colunm A ColunmB
01/17/2006 0.8631
01/18/2006 0.8618
02/19/2006 0.8625
02/20/2006 0.8613
03/21/2006 0.8582
04/22/2006 0.8661

i need formula to find average rate for colunm b for each month in colunm A

regrads

"Jacob Skaria" wrote:

Hi George

Could you please elaborate your query..preferably with an example...
--
Jacob (MVP - Excel)


"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