As you can see in the image I am using Sumproduct (offset combination to achieve sumproducts between Rate column and Title-X columns.
Number of rows to calculate sumproduct changes, so Sumproduct limits connected to Group No (from 3 to 3)
I am willing to change OFFSET with a non-volatile solution. But can find a way.Please Login or Register to view this content.
http://i.imgur.com/uwyX3VK.jpg
Bookmarks