Thanks! You'd think they'd make this easier. The whole issue came about
because Autofilter, while making it so you don't see certain cells on
the screen, doesn't exclude them from calculations that cover the whole
range. So I'm having to find ways to get around this. Thanks again,

Andrew