SUMIF Help
 

I have columns of data with the date entered in column A
in format MM/DD/YYYY. Column C contains cost data.

I am trying to sum up data to the side by month. The
formula I tried using is =SUMIF(A3:A38,"MONTH(A3:A38)
=1",C3:C38)and =SUMIF(A3:A38,MONTH(A3:A38)=1,C3:C38.

Neither method is evaluating the data correctly. Any
assistance would be appreciated.

TIA,
JC

If you'll want to get more than just January's data, I'd strongly
recommend using a Pivot Table, which can organize information by month,
quarter, week, etc. See

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Otherwise, you can use

=SUMPRODUCT(--(MONTH(A3:A38)=1),C3:C38)


In article ,
"JC" wrote:

I have columns of data with the date entered in column A
in format MM/DD/YYYY. Column C contains cost data.

I am trying to sum up data to the side by month. The
formula I tried using is =SUMIF(A3:A38,"MONTH(A3:A38)
=1",C3:C38)and =SUMIF(A3:A38,MONTH(A3:A38)=1,C3:C38.

Neither method is evaluating the data correctly. Any
assistance would be appreciated.