Hi Mike,

Thanks for trying to help :-)
I have used different formulas in the bottom row, and they always changed
when I made a selection in the auto filter. One example is average, which
doesn't change when I do a selection in the autofilter. This means that I
have to manually do a calculation for each selection.

Best regards,
Maria

"Mike H" wrote:

Maria,

Are you sure it wasn't subtotal that worked before

=SUBTOTAL(109,B2:B20)

With data in B2 to B20 this will sum visible cells only

Mike

"Maria" wrote:

I have made a excel sheet with filter function. When I use the filter, I want
the sum to reflect the rows that are visable, ie I want the sum to change
when I use the filter. It worked before, but now suddenly it doesn't anymore.