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)?

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.

"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