Help with basic formula, please
Not VBA (sorry, don't even know what that is!), only what will be a basic Excel formula, but I'd appreciate knowing how to do what I want as I'm an old dog learning new tricks and have only fairly recently taught myself to set up a spreadsheet in an old version of Excel (2000), and got stuck with this one. So if you wouldn't mind helping a bit of a simpleton...
How do I add two ranges of cells together and at the same time deduct another two ranges?
I can add two ranges of cells with SUM no problem, and the same with deducting one range from another, but need to combine the add and subtract elements together in one formula.
Written 'the long way', I want to add ranges A163:A184 and A208:A219, and deduct F163:F184 and F208:F219, all at the same time.
Or A163:A184+A208:A219-F163:F184-F208:F219
It'll only be a case of getting my brackets and/or commas in the right place, but haven't been able to hit on the right combination :(
Thank you so much.
SUM(A163:A184) +
SUM(A163:A184) + SUM(A208:A219)- SUM(F163:F184)-SUM(-F208:F219)
or (if there is no data between the tables)
SUM(A163:A219)-SUM(F163:F219)
Ah, I see... makes perfect
Ah, I see... makes perfect sense now!
Didn't twig I could have 'SUM' in the formula more than once -- as I said, only at a very basic self-taught level, picking it up as I go along, and I'd only ever needed SUM at the start till now.
There's data inbetween the two tables so it'll be the first option. It's monthly figures relating to and totalled for two different years, running Oct-Sep (which I don't want to change), but to analyse/summarise something for a different purpose I wanted to 'shift the year' to a different 12-month period, thus needing to pick out some months' figures from one year and the rest from another.
Many thanks for helping me out :)