Hi all
Some assistance please.
As per the attachment. Criteria is displayed in the "Totals" tab and the range and Sum Return are from the "Assortment" tab.
I would like the option of deleting certain cells (criteria), then for the formula to display the results from only the populated criteria.
Example. (on attachment)
CHAIN DEPT BRAND
AMS Footwear Adidas
If I only want to select the above criteria and exclude the others, then I need to delete the cells (criteria) which I've highlighted in yellow. However this then returns a ZERO. What do I need to do? I tried viewing past threads but cannot make it work.
Bookmarks