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