Forum Discussion
Solved
Determine total (sum) of individual items in 16 column x 200 row sheet
OK this might take some 'splainin' so ... I sell things online. Over 100 different things. I have a spreadsheet that tracks sales … Jane Doe, total sale, and a breakdown of what she bought b...
Another variant - sample
Randy, have you tried inserting a Pivot Table. If I am understanding your problem, then I feel sure a Pivot Table will fix it. Holler if you need help.
- Hi Harry ….
I am sure a pivot table could be used, but my issue is the data in the sale area which is what is of interest to me, is comprised of only some of the items I have available. So while I may have a list of a hundred or so items, the area with the purchased data won't contain at least one of each upon which to build a pivot. What I need is one part of the pivot to reference all my possible items for sale, with another part referencing only those items sold, so I could see, for example,
brant frame 7.5 121
brnic frame 7.5 0
brgun frame 7.5 239
and so on. I've tried to get a pivot to simply add what is in the sold items area alone to no avail.
