Exell Auto-calculating formula

  trekkieΩ 22:05 21 Jan 03
  trekkieΩ 22:05 21 Jan 03

I'm trying to create a monthly income sheet, and would like the formula to use for the last row of sells that will add up the whole months total.



  VoG™ 22:09 21 Jan 03

Lets say you have figures in A1 to A31 (for some months obviously the last row or three will be 0).

In A32 enter


You can copy this across to other columns.

If I've missed the point, please post back.

  trekkieΩ 22:20 21 Jan 03

Thx VOG, you know exactly what I mean, it's just that I'm as dumb as a doornail now. I've got a number of couloms that needs to be able to do this(Taxable Income, Non-Taxable Income, Expenses, etc.).

Is there a way to day it for the whole coulomn, rather than each individual sell?



  VoG™ 22:26 21 Jan 03

Do what I said above, then hover the cursor over cell A31. The cursor will turn into a +

Left click, hold down the left button and drag the mouse across all of the columns that you need to calculate. This will copy the formula across, changing the A into B for column B and so on.

  VoG™ 22:28 21 Jan 03

Actually, "hover the cursor over the bottom right corner of cell A31"

  trekkieΩ 22:35 21 Jan 03

You're the man VoG™, thx a lot and have a nice(wet and windy here) evening.


This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…