In a scenario where text values are interspersed with numeric data columns, the usual SUMPRODUCT function will not work. One will have to use a combination of array formulas and the SUMPRODUCT function.
You may refer to my solution in this workbook.
In a scenario where text values are interspersed with numeric data columns, the usual SUMPRODUCT function will not work. One will have to use a combination of array formulas and the SUMPRODUCT function.
You may refer to my solution in this workbook.
SUMPRODUCT function to work on a range with interspersed text values
{ 0 Comments }