Exell Auto-calculating formula

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

TIA

../

  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

=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 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?

Regards

../

  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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…