I am having an issue with my sumproduct formula.
I have attached a copy of my spreadsheet. I am using the sumproduct as my form for reporting up to the minute results.
In the Cascade Actual Summary tab, I used the sumproduct formula to report results from the cascade detail tab. When someone puts in the proper criteria it is supposed to automatically fill out my Summary tab to show what has been completed. In the far right 2 columns you will see under completed the new column and the % complete. This is the sumproduct formula that isn't working. It should be counting these but it isn't.
I was hoping for another set of eyes.
Thank you in advance.
Bookmarks