Exell Auto-calculating formula

  trekkieΩ 22:05 21 Jan 2003
Locked
  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.

TIA

../

  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

=SUM(A1:A31)

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?

Regards

../

  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