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.
Bookmarks