Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show last total from
I have a list in column f, which gives me totals from columns d and e. From
rows 9 to 1095 constantly. This is all good. But does anyone know how to bring up the last total in column f. e.g (cell f1096) should give me the last total from f9 to f1095. column d column e column f 9 5 6 -1 10 6 3 2 11 1 1 2 12 2 1 3 13 6 12 -3 14 ... ... 1096 As the last total is in f13, that total should appear in f1096 and when i enter the next total in f14 that should automatically appear in f1096 instead of f13. can anyone help? its just a formula i need to enter in f1096 -- please can you help... its urgent |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show last total from
Hi,
Not sure to fully understand ... Are you looking for the value of the Last Used Row in Column F ... ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show last total from
Look at your other post
"Moh" wrote: I have a list in column f, which gives me totals from columns d and e. From rows 9 to 1095 constantly. This is all good. But does anyone know how to bring up the last total in column f. e.g (cell f1096) should give me the last total from f9 to f1095. column d column e column f 9 5 6 -1 10 6 3 2 11 1 1 2 12 2 1 3 13 6 12 -3 14 .. .. 1096 As the last total is in f13, that total should appear in f1096 and when i enter the next total in f14 that should automatically appear in f1096 instead of f13. can anyone help? its just a formula i need to enter in f1096 -- please can you help... its urgent |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show last total from
its not working mike.. it gives me a #VALUE!
Is it because i got formulas in f9 to f1095 ???? -- please can you help... its urgent "Mike H" wrote: Look at your other post "Moh" wrote: I have a list in column f, which gives me totals from columns d and e. From rows 9 to 1095 constantly. This is all good. But does anyone know how to bring up the last total in column f. e.g (cell f1096) should give me the last total from f9 to f1095. column d column e column f 9 5 6 -1 10 6 3 2 11 1 1 2 12 2 1 3 13 6 12 -3 14 .. .. 1096 As the last total is in f13, that total should appear in f1096 and when i enter the next total in f14 that should automatically appear in f1096 instead of f13. can anyone help? its just a formula i need to enter in f1096 -- please can you help... its urgent |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show last total from
Hi,
Stop jumping around between threads and read your other post carefully. Mike "Moh" wrote: its not working mike.. it gives me a #VALUE! Is it because i got formulas in f9 to f1095 ???? -- please can you help... its urgent "Mike H" wrote: Look at your other post "Moh" wrote: I have a list in column f, which gives me totals from columns d and e. From rows 9 to 1095 constantly. This is all good. But does anyone know how to bring up the last total in column f. e.g (cell f1096) should give me the last total from f9 to f1095. column d column e column f 9 5 6 -1 10 6 3 2 11 1 1 2 12 2 1 3 13 6 12 -3 14 .. .. 1096 As the last total is in f13, that total should appear in f1096 and when i enter the next total in f14 that should automatically appear in f1096 instead of f13. can anyone help? its just a formula i need to enter in f1096 -- please can you help... its urgent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show total in a Stacked Chart | Charts and Charting in Excel | |||
make cell show blank when total is zero | Excel Discussion (Misc queries) | |||
I want the total in numbers to show not the formula | Excel Discussion (Misc queries) | |||
show aggregate total in pie chart | Charts and Charting in Excel | |||
How can I show the total sum of items in a filtered column | Excel Worksheet Functions |