SumProduct of Only Visible Rows

[ootkhopdi]

Hi All

i have a Sheet in which Rows 1 to 3004 having Diffrent values in Column I
total on rows 5 to 3004 in row no 3006
as sum product of Every 3rd Row as
=SUMPRODUCT(I$5:I$3004*(MOD(ROW(I$5:I$3004),3)=0))
with this formula i got sum value of row no. 6,9,12,15.......3000 and 3003
but i want to sumproduct of only these rows which are visible after apply filter
as
Row no.6,9,15,18,24,33,99 and 102 only
other way when i am applying filters in rows 5 to 3003 , then rows which are similar to filter creteria are visible
and i want to sum every nth rows of these filtered rows...

any one can help me...???

 

[Marcelo Branco]

See if this formula does what you need
=SUMPRODUCT(SUBTOTAL(3,OFFSET(I$5:I$3004,ROW(I$5:I$3004)-ROW(I$5),0,1)),I$5:I$3004*(MOD(ROW(I$5:I$3004),3)=0))

Hope this helps

M.