Add SumProduct to your Excel Arsenal.

SumProduct is one of the powerful excel formula that can take both horizontal and Vertical conditions to extract the data from given range as like sumif and sumifs, sumproduct too, extract the data from a particular column. Syntax is below \=SUMPRODU...