once data is filtered, how to sum up a particular col. value

[immerse]

Hi,

I'm interested to find out if its possible to sum a particular column value once its filtered and only sum up that which is shown on the screen or within a certain finite columns.

eg. i've got a series of columns such as

col a (Head co.)
col b (Values)

the entire spreadsheet contains like 15862 rows..

I filter by Head co. with autofilter,

and it subsequently shows the values...

so what id like is some code perhaps or if no code is good to, to simply now sum up the values of what is shown in col b after the filter..

hence it will change as the filter or as a different head company is chosen.

thanks again guys...

 

[Craig92604]

Re: once data is filtered, how to sum up a particular col. v

=subtotal(9,A2:A15862) Will only total the visibale cells. The 9 refers to the functions which is add and A1:A15862 refers to the range of cells