Solved: sum total based on month

[vzachin]

hi,

i need to add the number of entries based on month & year.
in column A12, i have numbers ; in column B12 i have dates.
in cell B3, i'm looking to add up the numbers in Column A12 for the month of January 2008.
i tried sumif but that didn't work out.
is there a formula for this or do i need to write some code ?



thanks
zach

[Bob Phillips]

=SUMPRODUCT(--(TEXT($B$12:$B$20,"mmm")=B$2),--(YEAR($B$12:$B$20)=$A3),$A$12:$A$20)

[vzachin]

thanks xldid
someday i'll understand sumproduct

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation.