Any way to make SUMIF only compute visible rows?

Hi everyone, is there any wat to make SUMIF only add visible rows like SUBTOTAL(9,... does? If not, do you know any way to accomplish what I need to do? Here's the scenerio:

DATA:
1 john 2002 600
2 jenn 2002 300
3 jenn 2004 500
4 jenn 2003 500
5 john 2003 500

Elsewhere on the worksheet...
2002 - 900
2003 - 1000
2004 - 500

Now, the user filters col 2 by Jenn:
2002 - 300
2003 - 500
2004 - 500

So, i need a condition to group years, but I want the user to be able to filter by the name too.

Hi

Using SUMproduct is probably the best bet

See www.xldynamic.com/source/xld.sumproduct.html for a full description and examples

Ed