|
Post by chaosisapony on Dec 27, 2018 16:51:59 GMT
I can't find this option anywhere and I'm really glad!
|
|
|
Post by NanaKate on Dec 27, 2018 16:54:45 GMT
So where do you see the total? I see all the purchases but not a grand total for the year.
|
|
freebird
Drama Llama
'cause I'm free as a bird now
Posts: 6,927
Jun 25, 2014 20:06:48 GMT
|
Post by freebird on Dec 27, 2018 16:56:23 GMT
no clue, it doesn't give me a total, just a list.
|
|
The Great Carpezio
Pearl Clutcher
Something profound goes here.
Posts: 2,936
Jun 25, 2014 21:50:33 GMT
|
Post by The Great Carpezio on Dec 27, 2018 16:57:20 GMT
1,290.88
|
|
|
Post by brenda89 on Dec 27, 2018 16:57:56 GMT
Not nearly as bad as I thought!!!! $1,705.82
|
|
Deleted
Posts: 0
Jun 1, 2024 22:56:08 GMT
|
Post by Deleted on Dec 27, 2018 16:59:10 GMT
Hmm, no total. Just a spread sheet.
|
|
|
Post by brenda89 on Dec 27, 2018 16:59:15 GMT
You have to export the report, it's a CSV. Which can be opened in Excel or Numbers, and played with to get totals.
|
|
|
Post by brenda89 on Dec 27, 2018 17:01:07 GMT
Go to Your Account -> Ordering and Shopping Preferences -> Download order reports
Then choose your date range
|
|
|
Post by Mel on Dec 27, 2018 17:02:57 GMT
$1036.25 Not too bad... LOL
|
|
|
Post by summer on Dec 27, 2018 17:06:13 GMT
$25 - I never shop on Amazon. I do a lot of online shopping but I buy directly from stores. I don’t like to deal with Amazon.
|
|
|
Post by kibble on Dec 27, 2018 17:06:31 GMT
Go to Your Account -> Ordering and Shopping Preferences -> Download order reports Then choose your date range Yes and in Excel you can use the formula =sum(#:#) so if you want to add B1 through B99 it would be =sum(B1:B99) that will give you the total for that column
|
|
|
Post by NanaKate on Dec 27, 2018 17:08:20 GMT
You have to export the report, it's a CSV. Which can be opened in Excel or Numbers, and played with to get totals. Thanks for the response. Lol I don’t want to know that bad!
|
|
Deleted
Posts: 0
Jun 1, 2024 22:56:08 GMT
|
Post by Deleted on Dec 27, 2018 17:08:28 GMT
I rounded down or up, so with 62 items we spent roughly $1,797.
Most expensive item was my $150 road bike trainer.
Most items are below $45.
|
|
freebird
Drama Llama
'cause I'm free as a bird now
Posts: 6,927
Jun 25, 2014 20:06:48 GMT
|
Post by freebird on Dec 27, 2018 17:10:09 GMT
Go to Your Account -> Ordering and Shopping Preferences -> Download order reports Then choose your date range Yes and in Excel you can use the formula =sum(#:#) so if you want to add B1 through B99 it would be =sum(B1:B99) that will give you the total for that column
I tried that, I use librecalc and it wouldn't do it. Oh well! I'm going to guess probably around $3k-$5k 168 orders.
|
|
scrappinghappy
Pearl Clutcher
“I’m late, I’m late for a very important date. No time to say “Hello.” Goodbye. I’m late...."
Posts: 4,306
Jun 26, 2014 19:30:06 GMT
|
Post by scrappinghappy on Dec 27, 2018 17:11:04 GMT
I looked OMG I totalled it and deleted that spreadsheet so fast. I hope dh never figures out how to do that LOL
|
|
|
Post by myshelly on Dec 27, 2018 17:18:38 GMT
It must be different on the mobile site, I don’t have Ordering and shopping preferences as an option.
|
|
scrapngranny
Pearl Clutcher
Only slightly senile
Posts: 4,765
Jun 25, 2014 23:21:30 GMT
|
Post by scrapngranny on Dec 27, 2018 17:19:23 GMT
I’m not even going to look. I buy a lot of stuff I’m too lazy to the city to get. Example, I just received felt pads for my kitchen chairs. They didn’t have what I wanted here in town and I didn’t want to have to go to several stores to find what I wanted. I get stuff faster than if I put on a list for the next time I go to the city.
|
|
|
Post by ~summer~ on Dec 27, 2018 17:20:07 GMT
$5285
|
|
|
Post by deekaye on Dec 27, 2018 17:20:29 GMT
|
|
|
Post by ~summer~ on Dec 27, 2018 17:21:02 GMT
So where do you see the total? I see all the purchases but not a grand total for the year. Just highlight the column and it will tell you a total in the lower right corner (will give you a 'count', 'average' and 'sum')
|
|
|
Post by PolarGreen12 on Dec 27, 2018 17:23:59 GMT
Mine is REALLY skewed because it doesn’t include kindle book purchases Yes that's true, it is physical purchases. I couldn't find where to include digital items. I haven't purchased any books but have rented/bought about 20 movies, so my actual total is probably quite a bit more. Mine is super skewed then. I only buy digital movies and they are all purchased from Amazon. I've purchased around 50 movies this year. My total before that was 1904.17.
|
|
Deleted
Posts: 0
Jun 1, 2024 22:56:08 GMT
|
Post by Deleted on Dec 27, 2018 17:25:48 GMT
Not as bad as I thought.
|
|
|
Post by annabella on Dec 27, 2018 17:29:35 GMT
$1133 I buy a lot of vitamins
|
|
Deleted
Posts: 0
Jun 1, 2024 22:56:08 GMT
|
Post by Deleted on Dec 27, 2018 17:30:15 GMT
It must be different on the mobile site, I don’t have Ordering and shopping preferences as an option. Yea, I had to log in to the full Amazon site.
|
|
|
Post by nnnsmom on Dec 27, 2018 17:37:15 GMT
$3041 😳
But I have to say, I’ve got two teens that have purchased a lot of car/truck parts on there with their own cards! 👍
|
|
|
Post by M on Dec 27, 2018 17:51:21 GMT
Spreadsheet was 202 lines long. Total was $3754.
Love Amazon.
|
|
|
Post by myshelly on Dec 27, 2018 17:56:10 GMT
It must be different on the mobile site, I don’t have Ordering and shopping preferences as an option. Yea, I had to log in to the full Amazon site. The full amazon site on my phone is a nightmare.
|
|
|
Post by stingfan on Dec 27, 2018 18:05:25 GMT
$9549.24
|
|
purplebee
Drama Llama
Posts: 6,738
Jun 27, 2014 20:37:34 GMT
|
Post by purplebee on Dec 27, 2018 18:06:21 GMT
Not as bad as I thought - $453. Thought it would be over $1000.
|
|
|
Post by papersilly on Dec 27, 2018 18:23:15 GMT
$2,036.00 and all delivered through Prime. makes that annual fee worth every penny because it's not about how much we order but how many TIMES we ordered.
|
|