Dynamic Filter-Dependant Formulas?

Greetings!

I am new to these forums, but somewhat experienced with Excel programming.

I have a Filter set up across a few columns of data. Lets say one of the columns is called "Hours", and another is called "User". There is another cell called "Totals" outside of the Filter.

What I would like to have is a self-updating Totals cell that will Sum the total number of Hours for whatever the Filter is currently showing.

Examples:

If I set the Filter to show only UserA's data, the Totals cell will Sum the Hours for UserA.

If I set the Filter to show All Users with Hours greater than 2, the Totals cell will Sum all the Hours greater than 2.

If I set the Filter to show UserB and UserC and Hours less than 5...well you get the idea.

Can I write a function that loops through the data that meets the Filter's criteria? Do I need to create a macro to update the Totals cell each time the Filter is changed? Is there an easier way that I don't know about?

Thanks in advance!


Pseudo-Code:

Totals = Sum( Filter Hours )