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.
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.
Apply the SUMPRODUCT() function on the visible cells of a filtered range
{ 0 Comments }