I found this awesome guide online for some dynamic formula's that I want to use:

https://www.youtube.com/watch?v=NbP-dHau9-I

His initial setup though requires a SUMPRODUCT formula to breakdown the initial items to. I'm having issues with my specific column area.

I am trying to pull two different pieces of information from these SUMPRODUCT Items:

1) Column A says "Y" while Column B is 0

2) Column A is blank but Column B has a number

I do not need Column A that say "Y" and column B with a number

Below is my first crack at

=SUMPRODUCT('Product 1 Roll-up'!A2:A99="", 'Product 1 Roll-up'!B2:B99>0)

I do have columns within A2:A99 that are blank and have numbers greater than 99. Its just not coming through, keeps coming in as 0.

If you need me to build a spreadsheet for reference I have no problem doing so, just hoping maybe its my formatting or something.