Evening guys,

Any help on this would be appreciated.

I have a column of numerical values. At the bottom of the column I have various formulas (sums, averages, count ifs)

Is there any where to make it so that if I filter another column it will effect the formulas? Currently when I filter other columns it has no effect on the formulas.

Thanks