Hello

I am having some difficulty working out how to exclude hidden (filtered) rows when using a SUMIF function.

=SUMIF(X8:X3000),2.0647,T8:T3000)

Can someone please assist with this problem

MT