Graph and data

J

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?
 
J

jtfalk

I think I have it - does it look correct:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top