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