This would be easier to use


=SUMPRODUCT(--(TEXT(Sheet1!$A$1:$A$150,"mmm")=A1),Sheet1!$B$1:$B $150)

change the cell references to fit your data then copy down





--


Regards,


Peo Sjoblom


"yowzers" wrote in message
...
Right now, I have a database in Sheet 1 by dates listed as 1/1/09,
2/15/09,
etc in column A and corresponding data in column B. Then I have a table
on
Sheet 2 where column A is listed in text as Jan, Feb, Mar, etc. I would
like
to put in a SUMIF function where I can get totals for column B on sheet 1
by
month IF the date in Sheet 1 column A equals the month listed in the
column A
in sheet 2. Right now, the only way I can do this is by creating a column
C
in sheet 1 and having the date in column A turned into a month by using
=TEXT(A1,"mmm"). Then in sheet 2, I use the SUMIF function where it sums
if
column C in sheet 1 equals column A in sheet 2. Is there anyway I can put
this all into one formula so I don't have to have that column C in sheet
1?