Calculate Amounts for Specific Dates

Column A has Dates.
Column B has corresponding Amounts

I want to calculate the average amount for a specific given month.

If my data has two months in September, and the Amounts for these dates are
1.23 and 5.26 respectively, then my average for September would be
(1.23+5.26)/2.

So I need to calculate how many dates have September as the month, and the
rows they are in to get the Amounts.

Suggestions please?

Thanks,
Bernie

=AVERAGE(IF(MONTH(A1:A200)=9,B1:B200)

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bw" <iamnu@cableone.net> wrote in message
news:11lujockv6lg880@corp.supernews.com...
> Column A has Dates.
> Column B has corresponding Amounts
>
> I want to calculate the average amount for a specific given month.
>
> If my data has two months in September, and the Amounts for these dates
are
> 1.23 and 5.26 respectively, then my average for September would be
> (1.23+5.26)/2.
>
> So I need to calculate how many dates have September as the month, and the
> rows they are in to get the Amounts.
>
> Suggestions please?
>
> Thanks,
> Bernie
>
>

Excellent!
Thank you sir.

Bernie


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OYDvDMh2FHA.3136@TK2MSFTNGP09.phx.gbl...
> =AVERAGE(IF(MONTH(A1:A200)=9,B1:B200)
>
> which is an array formula, so commit with Ctrl-Shift-Enter
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "bw" <iamnu@cableone.net> wrote in message
> news:11lujockv6lg880@corp.supernews.com...
>> Column A has Dates.
>> Column B has corresponding Amounts
>>
>> I want to calculate the average amount for a specific given month.
>>
>> If my data has two months in September, and the Amounts for these dates
> are
>> 1.23 and 5.26 respectively, then my average for September would be
>> (1.23+5.26)/2.
>>
>> So I need to calculate how many dates have September as the month, and
>> the
>> rows they are in to get the Amounts.
>>
>> Suggestions please?
>>
>> Thanks,
>> Bernie
>>
>>
>
>