Macro to find sum after manually filtering the column

[bent_dietrich]

Hello excel experts,
I am currently writing a macro that does a variety of things, one of these being that it automatically sums up columns I,J and K. The dilemma I have is that I need to be able to see the sum of the data in a cell at the bottom of the column, after manually filtering it according to what I want to see. Any help would be appreciated,
Best regards,
Bent