In addition ensure the cursor is in the formula bar when you hit Ctrl+Shift
+Enter and Excel wil add curly brackets {} around the formula. Note you can't
add these brackets manually.

"Mike H" wrote:

It's giving #VALUE! because you haven't entered it as an array formula

Paste the formula into a cell then hit CTRL+Shift+Enter.

Mike

"Moh" wrote:

not helping it gives me the following answer #VALUE!

Anything we might have missed out?
--
please can you help... its urgent


"Mike H" wrote:

Try this in F1096

=INDEX($F$1:$F$1095,LARGE(IF($F$1:$F$1095<"",ROW( $F$1:$F$1095)),1),1)

It's an array so enter with Ctrl+Shift+enter

Mike

"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