How to autosum data from filter ?

[conks]

Hi,

I've filtered a column with figures in it to reflect a specifi
client.

How do I then autosum the filtered data without including all of th
unfiltered data ?

Thank

 

[JON JON]

Take a look at SUBTOTAL Functions. I know it ignore hidden cells.

 

[RagDyeR]

From Debra Dalgleish's web site:

http://www.contextures.com/xlFunctions01.html#Filter

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Hi,

I've filtered a column with figures in it to reflect a specific
client.

How do I then autosum the filtered data without including all of the
unfiltered data ?

Thanks