Link to home
Start Free TrialLog in
Avatar of brasiman
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!
Example.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
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
Example.xlsx
Avatar of brasiman

ASKER

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.