Apply the SUMPRODUCT() function on the visible cells of a filtered range

{0 Comments}

The SUMPRODUCT() function works on all cells in the specified range - whether filtered or not.  However, one may want to apply the same function on the visible cells of a filtered range.

You may refer to my solution in this workbook.

Leave a Comment

Your email address will not be published.

*