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.

*