I recently added a SUMPRODUCT formula to one of my larger spreadsheets. It has completely bogged it down. I was wondering if someone could help with possibly a better formula w/ less calc time. What I am trying to achieve in the example below is to return a unique value where a customer only has a sale type of gross. In the example I use a sumproduct formula to achieve this to return a 0, but when I apply this formula to 100K+ rows of cells it is killing my already large workbook. Thanks in advance for the help.
Bookmarks