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../
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.
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../
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.
Actually, "hover the cursor over the bottom right corner of cell A31"
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.
OnePlus 5 review
50 best online Adobe XD tutorials
iPad Pro 10.5in (2017) review
Comment connecter un MacBook à une TV ?
© Copyright 2017 IDG UK. All Rights Reserved.