The last column is your order subtotals, but if you ordered multiple items in one order, the entire order subtotal shows up more than once.
For example, I ordered a car seat base, a sophie, and a taggie in the same order. The last column said $83 three times for that order even though the base was $56, the sophie was $17 and the Taggie was $10.
You want add up the column that gives you the price per unit. If you ordered more than 1 of some items, you first want to multiply that column by the quantity column.
I am an excel nerd.
Yea this is what happened to me. It counted a$500 order like 9 times because there were 9 items
Post by The Foozzler on Jan 5, 2013 10:51:06 GMT -5
In order to take into account ordering more than 1 of each item-
Click on column K and then insert a new column. Click on cell K2, type in =I2*J2 then hit enter. You can click the plus side in the corner of that cell and drag it down to the bottom of you orders. Now add up the total of your new column K.
You all make me feel better about my life. My order total was just over $1000.
The last column is your order subtotals, but if you ordered multiple items in one order, the entire order subtotal shows up more than once.
For example, I ordered a car seat base, a sophie, and a taggie in the same order. The last column said $83 three times for that order even though the base was $56, the sophie was $17 and the Taggie was $10.
You want add up the column that gives you the price per unit. If you ordered more than 1 of some items, you first want to multiply that column by the quantity column.
I am an excel nerd.
Oh well this will make my H very happy! I'll have to look at it again when I'm back on the computer.
Foozle, you are the best. I would have never been able to figure that. Actual Amazon spending = $4,939.41. Much more reasonable considering how much we buy on there!