Code:
--------------------
A B C D E F G
Jan-05
Info Date IF EB IF2 EB2
January
A Jan 01, 2005 1 1 1 1
B Jan 01, 2005 3 4 3 4
A Jan 02, 2005 0 0 0 0
Febraury
B Feb 03, 2005 0 1 0 1
C Feb 03, 2005 - - - -
March
A Mar 04, 2005 3 2 3 2
D Mar 04, 2005 1 0 0 0
April
A Apr 02, 2005 2 2 3 2
C Apr 02, 2005 - - - -
May
F May 20, 2005 1 1 1 1
A May 20, 2005 0 0 0 0
G May 08, 2005 5 0 5 0
June
A Jun 08, 2005 1 0 1 0
--------------------



Okay here is what I need help with.
The number of records that have a month that equals A1 and when the
value in column B is either A or B and when there is a value greater
than 0 in any of the columns D through G

Please let me know if you need further clarrification.


--
JustMe602
------------------------------------------------------------------------
JustMe602's Profile: http://www.excelforum.com/member.php...o&userid=27854
View this thread: http://www.excelforum.com/showthread...hreadid=473641