Excel Help Please

Colbaker · 10 Feb 2009 at 10:17

Calling all those Excel guru's out there...

I am trying to find an equation that will put the final number in a column into the cell, for instance i have 30 rows in column A and i want the equation in Cell A31 to give me what the last number entered in the 30 rows, Now the issue is that not all 30 rows can be populated i may on have 20 items in the 30 rows so will need to know what the 20th number is,

Hope ive explained it ok

Thanks

Colbaker · 10 Feb 2009 at 11:00

any idea what this means?

=SUM(L6)/SUM($F$5:F6)

what does the $ mean?

Colbaker · 10 Feb 2009 at 11:36

Thanks for the reply's guys, I could not understand that link hodders sorry, problem is i stupidly told my boss i would do this thinking that it would be easy (man was i wrong).

If i explain it better with a piccy, i need to fill in the orange cell with the last number in the column and if i add to that column it will automatically change the amount in the orange cell.

Thanks for the reply's guys, I could not understand that link hodders sorry, problem is i stupidly told my boss i would do this thinking that it would be easy (man was i wrong).

If i explain it better with a piccy, i need to fill in the orange cell with the last number in the column and if i add to that column it will automatically change the amount in the orange cell.

http://oneblondeeyebrow.co.uk/displayimage.php?album=random&cat=0&pos=-450

thanks.
thanks.

Colbaker · 10 Feb 2009 at 12:43

I thought the numbers were getting bigger as well but they aren't there are a few higher numbers in there.

Any other idea's?

Colbaker · 10 Feb 2009 at 13:05

O.k. i tried that as i am in column M so changed accordingly but it now comes up with #N/A would this be because it is currency? the output should be 25.49 as this is the amount in the bottom cell of the column, it would also seem as if the #N/A at the bottom of the column is causing issue's but i need to keep them in as they have another equation in them.

Ricky1981, you have a point there, Surely CUMULATIVE means the numbers should be going up?

Colbaker · 10 Feb 2009 at 13:17

All done.

Thanks for your help guys, I can now pass this off as my own work and get some kudos from the boss

(hopefully he then does not make me the chief excel spreadsheet creator)