Exell Auto-calculating formula

  trekkieΩ 22:05 21 Jan 2003
  trekkieΩ 22:05 21 Jan 2003

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 2003

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 2003

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 2003

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 2003

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

  trekkieΩ 22:35 21 Jan 2003

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.

Elsewhere on IDG sites

Best Black Friday Deals 2017

Black Friday Deals for Designers & Artists: Adobe, Apple, Corel Painter, Microsoft Surface, Wacom &e…

Best Black Friday Apple Deals 2017

Black Friday 2017 : date, sites participants & bonnes affaires