Hello, I received a product order from a retailer where he lists the quantities of each product he requires, I am trying to add up not the dollar amount of the total order but only the total quantity of his order, for example, he wants 2 of this, 3 of that, 5 of the other e.t.c, I am trying to use the auto sum feature after highlighting the entire quantities column but that is not working, help?

Hi
You need to post a sample so we can see exactly what you are trying to do.
Tony

Click in the cell the result will go then the AutoSum button then select the quantities.



*******************
Consider rating the thread by going to the "Rate Thread" dropdown.

Sorry guys, I am missing something here, please see attachment, you will notice different quantities for each item, some are 1, 2 and 3, as mentioned I would like to add up the total so if I had 3 items as in my example they would total 6 items. I clicked in the cell below the last item or entry in the sheet, then clicked autosum and it's showing what you see in 2nd attachment? I also tried selecting "sum" from the drop down menu in Autosum and it produces the same result?

Attached Images

	Untitled.jpg (117.8 KB, 13 views)
	Untitled2.jpg (105.4 KB, 13 views)

But you did not show the result.

Perhaps the entries are text rather than numeric.

If you look at the 2nd image on the bottom, you will see what I am seeing which is
=SUM(F12:F55)?

Like pulling teeth but I think I have it.
Excel quite reasonably assumes the relevant data does not cross a blank row. It would be correct in most cases.
In this case you have to change the equation to include the rows above the blank one.




*******************
Consider rating the thread by going to the "Rate Thread" dropdown.

Not sure I understand? I select the entire column of quantities plus one empty cell below the last entry and choose autosum from the Formulas tab and all I am seeing is ####

And what do you get for a total, compared to what you expect? Also, your formula starts summing from row 12 - is there a reason for not starting from row 1?

And, when you're asked to post a sample, it would be helpful if you did that, instead of posting pictures of the worksheet. Your sample should include some representative data (delete anything sensitive)? You can post files via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sorry I am not understanding what you mean by posting "sample"? My post #4 explains an example of what I am seeking and the 2 screenshots shows the actual spreadsheet so I don't know how else to explain this but let me try again with a different example.

You are selling 3 products, 15 ipads, 45 laptops and 30 iphones and you list them as normal in a spreadsheet such as :

ITEM QUANTITY
ipads 15
laptops 45
iphones 30

You simply wish to calculate only the quantity column so you wish to add 15+45+30, that is all.

oh, found the answer here:

http://www.youtube.com/watch?v=EmeRPJ5sG9o

OK, so your formula should do the job. Have you formatted the column width so it's wide enough to display the result?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

yes, I simply manually stretch any column to my desired width.

"Posting a sample" just means that the person taking the trouble to answer you for free on his spare time would like you to post a sample excel sheet. This can be useful because sometimes numbers look like numbers but are in fact text, which, in certain cases could be the reason for a problem. This cannot be seen on a picture.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Sorry, still don't understand because that's the reason I posted the 2 screenshots of the actual spreadsheet or you saying that instead of posting the screenshot, I should upload the actual spreadsheet?