Printable View
I'm trying to make up a simple spreadsheet on Microsoft Excel Starter for my weekly shopping trips. Right now I have a column for the item, the price, coupon and the total.
What I want to do is have the coupon column subtract from the price column, have those two total and then have a final total at the bottom of the page. I know it's very simple, but I can't figure out how to do it.
Any guru's out there? :-)
There is probably a template online - but you will need to add up the column with the coupons and the minus it from the shopping total -- do you know what version you are using?
That's exactly what I want to do, but I can't figure out how to enter the formula's.
I'm using Starter 2010
This is the formula for sum =SUM(A2:A4) plug this in and change the cell numbers to whatever you want. You can drag the formula down the column to add up subsequent rows.
For the difference between to columns the formula is =A2-A3
I don't do it myself, but an SC member posted some excel savings charts - check here on post 112
http://forum.smartcanucks.ca/90767-d...ator-canada-8/