View Single Post
  #1   Report Post  
Lisa
 
Posts: n/a
Default 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?