How To: See Your Lifetime Amazon Tab (& Wallow in Your Painful Consumeristic Guilt)
How much you've actually spent and how much you think you've spent are usually two completely different results, and is especially true on Amazon when it's so easy to click and buy. You might think you've given Amazon a couple thousand over your lifetime, when the fact is that it's three or four times that amount.Well, thanks to a tip from Business Insider, there's a way to quickly and easily check your entire purchase history, for better or for worse.
Step 1: Request Order HistoryFirst, go to Amazon.com, hover your mouse over Your Account on the top right of the page, and then click "Your Account" on the drop-down menu. Then, under Order History, you should see "Download Order Reports"—click on that. You'll be taken to a page where you can request order history reports.Set the Start Date to January 1 and the year that you opened your account (it will be the earliest year listed in the drop-down). Then you can press the link next to End Date that says "Use today" to fill out today's date automatically. You can add a name to the report if you'd like, but it's optional. Click on the "Request Report" button to have Amazon begin amassing your history. It may take a little while to process, and Amazon will email you the report so you don't have to stick around.
Step 2: Download ReportOnce your report is done, you can download it on the Order History Reports page on Amazon, or through the link sent to your email. Save the file to your computer (it may automatically download as a CSV spreadsheet after the report has finished loading), then open it up your preferred spreadsheet software. I'll be using Google Sheets, but it'll work the same in Excel and Numbers.
Step 3: Calculate Amount SpentStart a new blank document, and then go to File -> Open. On the Open a file screen, click the "Upload" tab, then drag the Amazon report file into the dashed box, or click "Select a file from your computer" and choose the Amazon file in your directory. You'll now see a list of everything that you've purchased on Amazon, but we still need to pop in a quick formula to tabulate your total amount spent. Look for the column that says Purchase Price Per Unit (M). Now, highlight the cell directly under the last item on the list (or maybe two rows below, if you'd like some breathing room). Type in the phrase =SUM( in that cell and press enter/return, which will add up the values of the cells you select. Next, you'll need to choose the cells in the Purchase Price Per Unit column. Click on the first price in the list, and it will highlight in pale orange. Then, go down to the last price in the list and shift-click on that item. You should see the entire column range highlighted if you did it right. After that, just hit enter/return again, and there you'll have it—the total amount of money you've spent on Amazon.Example: =SUM(M2:M16) Of course, this total only applies to purchases as a single quantity. If you ordered more of the same item in the same order, you'd want to use a =SUMPRODUCT formula instead of the regular =SUM formula. This will multiple the price and quantity before adding them all up together.Type in =SUMPRODUCT( then shift-click to select the amount ranges in the Purchase Price Per Unit (M) column. Add a comma (,) then shift-click the same range in the Quantity column (N) and press enter/return to finish the calculation.Example: =SUMPRODUCT(M2:M16,N2:N16) There's plenty of stuff you can do with this data besides seeing your total amount spent. Like, you could go through your purchase history and ask yourself if it was worth spending $10 on a poster for a Nicolas Cage movie that maybe 14 or 15 people have seen.Who am I kidding? Of course it was worth it. Try downloading your own Amazon report, and let us know in the comments about the most ridiculous item you've purchased in your Amazon history.
Cover image via Shutterstock
This is the "Learning Android Functions" video from the "How To Use Android Phones: The Video Guide" vook. To learn more about this or other Vook titles, please go to
Your Apple TV will stream a mirror of whatever is on your device's screen. (You can also just use AirPlay to stream media from the iPhone to the TV, such as music or videos you've purchased on
How to connect your iPhone or iPad to your TV | TechHive
Apple's new iPhone XR, XS, and XS Max are sure to be hits this year. Of course, that means plenty of hungry customers are looking to sign up for a model once preorders begin on Friday, Sept. 14, for the XS models, and Oct. 19 for the XR.
iPhone XS vs. XS Max vs. XR: how to pick between Apple's
Gmail by default gives 11 font choices which are more than enough for an average user. But sometimes we would like to have stylish fonts used in our mails to impress our friends or standard font mail for business communication.
How to Add Different Fonts to Gmail | Your Business
LastPass is a password manager that's been around for some time, and has finally made its way over to Android for use with apps, not just websites. Just imagine logging into your banking app without having to input that password every single time.
There are several different ways to back up a Mac, and for absolute safety, you should use all of them. Incremental macOS backup. This type of backup makes a copy of all your data the first time you run it then, at regular intervals, scans your Mac, identifies files that have been added or changed, and copies those to a backup file.
Easiest ways to backup your Android phone - Flash Stock Rom
With TeamViewer's free non-commercial software, you can rescue your parents, grandparents, and friends from their computer issues. Troubleshoot their tech issues, from anywhere. Fix IT Issues Remotely , With Zero Hassle!
5 Ways to Troubleshoot an Amp - wikiHow
How to Install TWRP Recovery on OnePlus 6 • Android Jungles
In this video, you shall get to know, how to customize some of your phone's UI elements, display battery percentage on battery icon in status bar, change order of tiles, add or delete tiles in
How to Hide the VPN 'Key' Icon on Android — No Root Needed
How to get Oreo-like features on any Android phone How to "There's no question Android phones are the best," "iPhones are worth every penny," "Only a dolt would use an iPhone
iPhone vs Android: Which Is Better? - Lifewire
Download Magic Screen Customize Your Lock & Home Wallpaper and enjoy it on your iPhone, iPad, and iPod touch. Cast a spell to make your very own wallpapers! Magic Screen renders the most amazing iPhone wallpapers for you.
Change Your iPhone & iPod Touch Wallpaper or Lock Screen with
Everything you need to know about the 2019 FIFA Women's World Cup™ 4 Dear Lindsey Horan: An open letter to the American midfielder ahead of her first FIFA Women's World Cup™
FIFA Soccer - Apps on Google Play
How To: Turning Video Clips into High-Quality GIFs Is the Easiest Thing Ever with Imgur Raspberry Pi: Physical Backdoor Part 1 How To: Produce and mix hip hop drums in Avid Pro Tools 9 How To: Use the Transport tool in Pro Tools SE
Building an Electric Bass Guitar: Part 1 - Design Considerations by Lee Laird Click on any picture to see a larger version. For those who may not know, I've been playing musical instruments most of my life, with guitar as my primary instrument. For the non-guitar players, Bass guitar has the same note structure as the guitar.
3 Ways to Teach Yourself to Play Bass Guitar - wikiHow
0 comments:
Post a Comment