Subtotal a filtered range

Hi MDarcey,

If you use the normal SUBTOTAL functions (1-11) it will account for filtered lists and only subtotal the visible cells (at least that's how it works in 2007).