Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a table which includes the date, Expected expenditures and
actual expenditured: Date Expected Actual 1 10 10 2 10 11 3 10 9 4 10 8 5 10 12 6 10 7 10 8 10 9 10 etc. At the end of the date, I enter the actual expenditures for that day. Now, for example, say it is the end of the 5th day of the month. I have a sum function at the bottom of actual which is sum(above). How can I get a sum of the expected only up to that current date for which i have entered data into the actual column, so as to compare total expenditures so far with expected expenditures up to this date? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Go to Next Empty Field | Excel Discussion (Misc queries) | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
In Bar Chart, can we display both figures and their respective %a. | Excel Discussion (Misc queries) |