Hi, i need to sumif by column and row criteria, i know this can be achieve by using Sumproduct.
However, i wish to know if its possible to Return the Sumrange column using Index/Match so that i can use Sumif instead.
I am not a fan of Sumproduct....
Bookmarks