Cost per use is the price you paid divided by the number of times you have used the thing. The number is high on day one and falls every time you use it, which makes it a fair way to judge a pair of shoes, a gym membership or a bike. A two-tab sheet can calculate it for you from a simple log.
Why is cost per use better than the price tag?
₹4,800 for running shoes sounds like a lot. After 120 runs it is ₹40 a run. A ₹900 pair worn four times is ₹225 a wear. The price tag does not tell you which was the sensible buy; the usage does. The log does the counting, so you do not have to remember.
How do you lay out the two tabs?
Tab one is called Items, one row per thing you bought. Tab two is called Log and is just a date and an item name each time you use it.
| Items column | What goes in it |
|---|---|
| A | Item name, exactly as you will type it in the log |
| B | Price paid in rupees |
| C | Date bought |
| D | Uses so far |
| E | Cost per use |
| F | Months owned |
| G | Cost per month |
On the Log tab, column A is the date and column B is the item name. Keep item names consistent. If you type Running shoes once and Runing shoes another time, the count will miss it.
What are the formulas?
- Uses so far, in D2: =COUNTIF(Log!$B$2:$B$2000, A2)
- Cost per use, in E2: =IF(D2=0, "", B2/D2)
- Months owned, in F2: =MAX(1, DATEDIF(C2, TODAY(), "m"))
- Cost per month, in G2: =B2/F2
MAX(1, ...) stops a division by zero in the first month. DATEDIF works in Excel and in Google Sheets. To see the number as of another date, replace TODAY() with a date cell.
What does the worked example show?
These numbers are made up to show the arithmetic. Say you bought running shoes for ₹4,800 and a gym bag for ₹1,500.
| After | Shoes: uses | Shoes: cost per use | Bag: uses | Bag: cost per use |
|---|---|---|---|---|
| 1 month | 8 | ₹600 | 10 | ₹150 |
| 3 months | 30 | ₹160 | 32 | ₹47 |
| 6 months | 70 | ₹69 | 75 | ₹20 |
| 12 months | 120 | ₹40 | 140 | ₹11 |
The cost per month for the shoes after twelve months is 4,800 divided by 12, which is ₹400. A bike that cost ₹36,000 and has been ridden 90 times in a year works out at ₹400 a ride and ₹3,000 a month. That may be fine if the alternative was paying for rides, and not fine if it sits in the stairwell.
Is it worth buying again, or should you sell?
Compare cost per use with what the alternative would have cost for the same use. If a bike costs ₹3,000 a month and would otherwise have meant ₹150 in rides, then 20 rides a month is break-even. This is a personal sense-check, not a rule. Add a column called Replaces if you want to note what you would have spent instead.
What stops the log from going stale?
- Put the Log tab next to the Items tab and add a row on the day, not later.
- Use a drop-down list on column B of the Log, with the item names from Items, so spelling is never an issue.
- Once a quarter, glance at the cost per use column and decide whether any item deserves to stay on the list.
Which purchases suit this method, and which do not?
It suits things you use repeatedly: footwear, a bag, a sports kit, a bike, a gym membership, a kitchen appliance, a pressure cooker you use every day. It does not suit one-off items such as a gift or a wedding outfit worn once, where the point of buying was the occasion. For a membership, log each visit as a use, and the cost per visit tells you plainly whether the monthly fee is earning its place.
If you would rather not type purchase prices by hand, SpendixAI can bring the amount in from an imported statement, and you keep the usage log in the sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

