PDA

View Full Version : Solved: sum total based on month



vzachin
01-07-2008, 11:18 AM
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
01-07-2008, 02:29 PM
=SUMPRODUCT(--(TEXT($B$12:$B$20,"mmm")=B$2),--(YEAR($B$12:$B$20)=$A3),$A$12:$A$20)

vzachin
01-10-2008, 06:01 AM
thanks xldid
someday i'll understand sumproduct

Bob Phillips
01-10-2008, 07:01 AM
Take a look at http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation.