=sum with a filter
 

Hello All,

New to the forum and just after a little help!

I have a spreadsheet and I've put a filter on but when I try and add the column up it includes the unfiltered values as well?

Is there a way of just adding the filtered items?

TIA
C

=sum with a filter
 

Hi,

Am Wed, 23 Jan 2013 13:36:49 +0000 schrieb CJH:

I have a spreadsheet and I've put a filter on but when I try and add the
column up it includes the unfiltered values as well?

for filtered data use SUBTOTAL. For Sum A1:A100:
=SUBTOTAL(109,A1:A100)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Hi CJH

Have you looked into the SUBTOTAL function or if you have Excel 2010 use the AGGREGATE function.

Kevin