Jo

Have a look at Help under "subtotal function".

Shows the formulas to use.


Gord Dibben Excel MVP

On Mon, 14 Nov 2005 09:42:10 -0800, "Jo Davis"
wrote:

Sorry

You can tell it is Monday, i want the St Deviation to update/change with the
new filtered information, is this possible?


"Jo Davis" wrote:

Hi

Can you have a formula that updates when you use a filter?