SUMPRODUCT The Alternative of Many Formula, Knowledge You Can Use...

SUMPRODUCT is a very useful function, you can use this function in place of Vlookup, Hlookup, Index, Match, Sumif, Sumifs, Countif, Countifs etc..

SUMPRODUCT,COUNTIF,Countifs,Sumif,Sumifs,Index,Match,Excel VBA,