Graph and data

[jtfalk]

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?

 

[jtfalk]

I think I have it - does it look correct:

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

 

[jtfalk]

I jumped the gun a little . I have what will work - but is there a better way
since each month I have to add in that months numbers - see below.


August =
=IF(--(TEXT(TODAY(),"mmyyyy")>="082009"),SUMPRODUCT(--(TEXT(C$6:C$505,"mmyyyy")="072009"))+SUMPRODUCT(--(TEXT(C$6:C$505,"mmyyyy")="082009")),"")


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