All,

I've done quite some searching through this forum and somehow can't seem to find the result I'm looking for. I'm essentially trying to set parameters based on the product options we allow. See below:

Screen Shot 2017-06-27 at 7.18.39 PM.png

Essentially I'm looking to put in the criteria, and hoping I can get excel to just generate all the available options.

I would then save that database and pull a running report daily from our website and drop it into a "data" tab. Once there, it would have a consolidated page that did countif based on the criteria. (I'd eliminate all the "0"s to reduce the size. However, would want to run it against everything.

Let me know if you have any questions! Thank you all for the help.