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

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?