quote:

Originally posted by Gustofer:
In Excel, highlight the "P" column (just click on the P. Then go to the "formulas" tab and click on Autosum (Greek sigma). Your total will be at the bottom of the column.

You sure about that? In my spreadsheet, column P is purchase order number. Column AD is the total price I paid in my spreadsheet.

JP

Mine is taking a few minutes to process...that can't be good!

quote:

Originally posted by jprebb:

quote:

Originally posted by Gustofer:
In Excel, highlight the "P" column (just click on the P. Then go to the "formulas" tab and click on Autosum (Greek sigma). Your total will be at the bottom of the column.

You sure about that? In my spreadsheet, column P is purchase order number. Column AD is the total price I paid in my spreadsheet.

JP

It doesn't appear to be consistent between each person. For instance, the "purchase price per unit" for me is under the "M" column. But it doesn't matter. Whatever column your price list is under, just click the column letter at the top to highlight the whole column, and at the bottom of your screen should be the average, the count, and the sum total.

I spent $32,000 since 2009. Just think of all the gas I saved!

Last time I looked, I found I had 87 Prime orders in 2017. I don't want to know. Wifey buys books from them by the ton.

Started running at 7:27. Let's see how long that takes to earliest available date....

Never mind - report failed. Guess AMZN doesn't want me to be shocked and is protecting me from myself. Perhaps I can ask Alexa.....

2010 forward seems to have worked and is only 816 lines. I'm not saying it's over $50K, I'm just claiming that one or two things on there were purchased for work.