excellent explanation of both methods. please note that sumproduct should only be used where you are only doing it for a number of cells. For large-scale use, the sumif index match should be used as sumproduct will make recalc times VERY VERY SLOW if it's being used hundreds of times or greater across a large dataset.
excellent explanation of both methods. please note that sumproduct should only be used where you are only doing it for a number of cells. For large-scale use, the sumif index match should be used as sumproduct will make recalc times VERY VERY SLOW if it's being used hundreds of times or greater across a large dataset.
huzcer 5 months ago
@huzcer , Yes SUMIF is much faster calculating than SUMPRODUCT!
ExcelIsFun 5 months ago