|
Post by a'Lan Mandragoran on Sept 12, 2011 22:05:14 GMT -5
I'm making a spreadsheet to keep track of my credit card. I have my monthly balance currently at 0. It shows that I'm paid up, but I want to be able to add the entire year's worth of charges and have them show whatever I still owe on the card in one box. Is there a way to show this in one cell and not have to go month by month?
|
|
|
Post by KG on Sept 19, 2011 13:31:22 GMT -5
Sorry, I don't have a clue Lan. Sounds like more of a Kata question... but it's good to hear from you. `
|
|
|
Post by ShutterBug on Nov 1, 2011 20:27:32 GMT -5
There is, but I'd have to be looking actually at the spreadsheet... Do you mean, like a sum, in one box?
|
|
|
Post by Kata Samoes on Nov 16, 2011 1:39:34 GMT -5
Shutterbug is right, it depends on how you're wanting to look at the information.
What I would recommend is breaking it up month by month, with each charge adding up for the monthly balance (so you can better track your progress), and then add the "sums" of each month as a total in one cell. Don't break it up into pages, though, or you cannot add it up. It's a giant spreadsheet, but if your software allows you the room, it's the best bet you have.
Either way you go about it, you can, it's simply "a1+b12+(etc etc)=SUM". If you go in ranges, instead of breaking it up, you have to put the numbers in one column or row to keep it simplistic (or it's a mathematical nightmare, at least what you'd have to type out). I haven't used Excel in a while though, to remember how to type in a range, however, sorry.
|
|