ExcelBanter - Graph and data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Graph and data (https://www.excelbanter.com/excel-programming/432153-graph-data.html)

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?

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?

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")),"")

"jtfalk" wrote:

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?