Excel 2007 : Using SUMPRODUCT with dates???

First off let me say hello to this forum!!! I hope to contribute as much as I get out.. but after looking at some threads.. everyone is pretty far ahead of me in the knowledge department.

I have a spreadsheet of products that I receive and then have the shipped out. I have used sumproduct in the past to get the #'s i need but now I would like to see them broke down to months and year to date #'s. Here is what i use to get MONTH data from my list:

=SUMPRODUCT(--(TYPEA=M12),--(TEXT(DATEA,"mmm/yy")=$D$32))

TYPEA = Product type column
M12 = Product
DATEA = Date column in ( in DATE format)
$D$32 = JAN/11

This works great for MONTH in and outs.

My question is HOW can i get that to give me TOTAL YEAR using that same format or what do I have to do to get year info from it.

Thanks in advance!!

Mike

Hi and welcome to the board

Maybe =SUMPRODUCT(--(TYPEA=M12),--(year(DATEA)=your_year)

Or depending on your data and what you need,maybe a Pivot Tbale can help

WOW!!! And that took all of 7 min! Thank you for the help!!

I have tried PIVOT tables but i cant seem to wrap my head around them!!!