Hi Jennie,

assuming your months are in column A and your products are in column B

in C1 put this formula

=COUNTIF(A1:A100,D1)

Now put the number of the month you want to count for into D1.

This will only count the amount of times the month appears in column
A.

If you need help counting products per month or anything else come
back

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381263