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