a b c d
1 item cost qty =c1*b1
2 item cost qty =c2*b2
total =sum(d1.d2)
all quantities should be blank except for the items you want to total.
I am not aware of a method that allows you to add a quantity simply by clicking the item that you want to add. Typing "1" in the quantity column next to the items you want to tally is doing essentially the same thing. In the total column you multiply the cost column by the quantity column. If the cost is in cell b1, and the quantity is in cell c1, the the formula in the total column should be =b1*c1. Any row that doesn't have a quantity will be ignored and the sum at the bottom of the total column should be for only the items that you "Checked" by placing a 1 in the QTY column.
The formulas I offered above are for an excel spreadsheet. If you use these formulas your spreadshett would look like the following example:
ITEM COST QTY TOTAL
Base Fixture 100 1 100
20 watt lamp 10 0
40 watt lamp 20 0
60 watt lamp 30 0
100 watt socket 50 1 50
100 watt lamp 40 1 40
lens filter 5 1 5
total 195
×
The first thing is that
you should describe your item clearly and completely. Check the ISBN, UPC or
product number and make sure that ALL details match with what is listed on
Amazon website.
Make sure that your price is reasonable. You
cannot expect to sell an item in the price that you originally bought it. For
books I would say you may expect getting 20-30% of original price. However it
varies from book to book. Sometimes a book is really rare that you can sell it
for double the price that you originally bought it and sometimes you should
reduce your price a lot.
Make sure to check your items and see if your
item is the lowest price or not. For the beginning you should probably expect
little money and as time passes by you get more feedback from people and hence
you can expect selling more items with better price.
Amazon maintains
consistency, i.e. they do not tend to make changes often. This is good for you as a seller since changes cost time. When
changes are made, they tend to stick and sellers
can adjust. Here are more tips for selling on amazon which helps you to increase sell on amazon.
93 views
Usually answered in minutes!
I have a Base Fixture that cost $100
The 20Watt lamp cost $10
The 40Watt Lamp cost $20
The 60wat lamp cost $30
The 100Watt Socket cost $50
The 100watt Lamp cost $ 40
The optional Lens Filter cost $5
I want a Base fixture $100
With a 100Watt Socket $50
and a 100Watt Lamp $40
and a Red lens Filter $5
I click on the desire check list and I want to see the Total $195
How do I do this in Excel?
×