SUMPRODUCT function to work on a range with interspersed text values


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.

Leave a Comment

Your email address will not be published.