yeah I need help with counting products per month, if you don't mind helping
me with that

"greg7468" wrote:


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