Link to home
Start Free TrialLog in
Avatar of brasiman

asked on

How to summarize a list

I have an order form with a list of items. I am trying to find a way to summarize that list on a separate tab, but only with the items they want to order, that has a quantity greater than 0. I attached an example. I tried a pivot, but can't get it to look nice. I would also like to be able to filter it if possible. It needs to look nice. Thanks!
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Professor J
Professor J

please find attached with formula
Avatar of brasiman


The vlookup is a good idea but I need the ability to only see those items that have a quantity of >0. I was hoping to use something other than a pivot but might be my best option.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.