Sums, Filters and Events oh my!

[Merlin]

Okay fo starters I may very well be making this harder then it needs to
be.

My overall goal is to sum up 4 columns and have that sum change and
reflect the use of filters.
Unfortunately I had no luck finding a way to have the Sum function
ignore rows that were filtered out.

So I wrote a little VB script that does this for me.
What I would really like to do now is link that VB script to a 'filter
event', so when you change the filter, the totals automatically update.

There doesn't seem to be a filter event.

I am sure once again I am missing something obvious.

Thanks in advance for what I am sure will be a number of useful replies.

 

[Guest]

Your missing the subtotal worksheet function which will do what you want
without events or code.

=subtotal(9,A1:A200)

the first argument defines the math operation to perform. 9 is sum, 3 is
count as examples. See Help in excel for details.

 

[Merlin]

Yep, that is what I needed, I knew I had to be missing something
obvious. Thanks a bunch.