wilkes

I always do two, Keeps your at a glance figures separate, easier to spot errors.

Cool!! Hopefully that'll help.

I just emailed like2laugh a worksheet kinda like you described Sweet

I agree with the others that using separate columns for debits & credits would work better. You can always insert rows in order to add more rows in the formulas. Also, you could d)o a formula in a cell that keeps a running total. For example, if you have one cell be the totals of all the debits and one cell be the totals of all the credits, you could then take the two and subtract one from the other in another cell which would be your running total. (if that makes sense)

I have an excel worksheet I created for an accounting class that might do but It won't let me send it as an attachment on here

I'm not that knowledgeable with Excel but when I want a total I highlight the entire row and hit autosum. That gives me a total for the entire row.

Just one account, I just want a better way of tracking what goes in and what goes out.

two colums then just put in the formula you subtract debits from credits

one acct or multiple?

I need some help creating a spreadsheet in Excel. The purpose of the spreadsheet is to track debits and credits. Should I use one column for debits and credits or should I use two separate columns? The main thing I need help with is how to keep a running total? Any help would be great.