| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graph and data
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Graph and data
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Graph and data
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to retain data in table only but do not graph of that data | Charts and Charting in Excel | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) | Excel Discussion (Misc queries) | |||
| Creating a graph with existing data...clear data after save | Excel Programming | |||
| adding data table with different data to a graph | Charts and Charting in Excel | |||
Linear Mode
