Using filter and sum formula together

[rpriestley]

I am using a sum formula =SUM(D8:D34) to count values when I use the filter function how do I ignore the hidden rows.

Thanks

 

[Cbrine]

rpriestley,
Have you tried using the subtotal function instead? I believe it would be Subtotal(9,D3:D34). This will ignore the hidden lines data.

HTH
Cal