That is why I did suggest an alternative in your other post using the TRUE/FALSE and Countif combination of helper columns..Sheet1, I can't imagine indexing a column with SUMPRODUCT() in that manner. By the time you get down to the 10,000th row, you're adding tens of thousands of calcs PER cell. Holy cow.
![]()
Bookmarks