without pivot tables

=SUMPRODUCT(--(MONTH(A2:A200)=1),B2:B200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"news.telenet.be" <testbunny69@hotmail.com> wrote in message
news:zfQ1g.382811$HC6.11122760@phobos.telenet-ops.be...
>
> Hello,
>
>
>
> Can someone help me with this problem:
>
>
>
> A B
>
> 1/1/2006 152.3
>
> 3/1/2006 156.2
>
> 8/1/2006 186.1
>
> 5/2/2006 185.2
>
> 19/2/2006 145.2
>
> .. ..
>
>
>
> I need to sum from all data on a monthly base.
>
> Jan : ..
>
> Feb : ...
>
> March : ...
>
>
>
> I already tried with a new column C who has the month number and then
using
> the "Sum. If" function. But can it be done without a extra column just 1
> formula per month?
>
>
>
>
> Thx in advance.
>
>
>
>
>
>