I think I have it - does it look correct:

=IF(--(TEXT(TODAY(),"mmyyyy")="092009"),SUMPRODUCT(--(TEXT(C$6:C$505,"mmyyyy")="072009")),"")

"jtfalk" wrote:

I have the following information

Graph Input
Month open closed accum open accum closed

July 9 2 9 2
August 15 2 24 4
September 0 0
October 0 0
November 0 0
December 0 0
January 0 0


Now I need to fill in the accumualted open and closed but do not want the
numbers to be in there until it is that month and then sum them so after
9-1-2009 I would like to have the cell then populate with the 24 + how every
many are opened that month.

Any thoughts?