I'm doing my taxes and I have a 1099 from a project that needed a TON of little pieces bought at different times, so I have a bajillion receipts. I would like to make a simple spreadsheet that lists the date, description, and price. Having it automatically add up the prices would be nice, and if it could automatically sort by date, that would be AWESOME. I'd need 50 lines or so. So can someone explain how to do that? Or if it's not too much trouble, could someone make a template for me? I really have no idea what I'm doing.
Excel should be able to do that no problem, but its been too long since I've worked with it, so give this thread a bump early in the marnin.
Just "SUM(Aa:Ab)" formula to add up all you cells into another cell.
You can sort the cells, IIRC by date after they are inputted into the sheet. Just highlight all you cells to perform the sort. IIRC. I would just sort manually first tho before inputting to the sheet. just to save aggrevation.
Corey, PM me tomorrow and I will give you my number, if you want to talk about this. Ranger is right on the money but if you need more clarification, let me know.
SVreX
MegaDork
2/18/13 11:24 p.m.
You've got mail.
I made it as easy as I could. 
Yeah, just type it all in. Once you're done, if you're using Excel 2007 (can't remember if this is there in the earlier version), you can just right-click the column that has all the dates in it, and you can sort Oldest to Newest (or reverse). Then, highlight all of your cells that have the prices in it, and there's a button on the toolbar that will do the sum (uppercase Sigma, looks like an E)
Thanks Paul!
I've now got a template and some instructions on how to use it, but if I have any more questions or run into problems I'll post them. Thanks everybody!
