You could use

=SUMPRODUCT(--(MONTH(A1:A100)=1),B1:B100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jnorton" wrote in message
...
I have a column with dates in it (Jan-12-2004) I have another column with
the
transaction price in it like $21.95.

I need to sum the column by month. I can do mid(Jan-12-2004,1,3) to take
out
the info except Jan but then how do you sum from that point on.