SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY
I have a formula at the top of a columnn to calculate the SUMPRODUCT.
However, I need the SUMPRODUCT to recalculate the visible cells only
when I filter the column. I don't think that the SUBTOTAL function
will work. Any suggestions?
|