There's an example here that counts visible cells in a filtered column.
You could modify the SUMPRODUCT formula to reference your cells, and add
one more argument that refers to the cells to be totalled.
http://www.contextures.com/xlFunctions04.html#Visible
In the above example, the modified formula:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10)-MIN(ROW(A2:A10)),,1)),
--(A2:A10=A12),--(D2:D10))
would total the visible cells in column D.
Lisa wrote:
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?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html