date criteria with SUMIF or SUMPRODUCT

[Addy]

Below is what I have

A B
Date Total
------ -------
Oct-2005 50
Nov-2005 79.3
Dec-2005 76.4
Jan-2006 81
Feb-2006 46.5
Mar-2006 73.6
Apr-2006 106
Oct-2005 150


I am trying to sum up the total column by a certain date criteria from
Column A.

Below is what I have and it is giving me an error.

=Sumif(A2:A8 = Oct-2005, B2:B8)

For some reason this formula is not working.

 

[Die_Another_Day]

Your syntax is wrong for sumif. try this:
=Sumif(A2:A8,"=Oct-2005", B2:B8)

 

[Bob Umlas]

=SUMPRODUCT(--(MONTH(A2:A8)=10,--(YEAR(A2:A8)=2005),B2:B8)

 

[Bob Phillips]

Typo Bob

=SUMPRODUCT(--(MONTH(A2:A8)=10),--(YEAR(A2:A8)=2005),B2:B8)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)