Hi CJH
Have you looked into the SUBTOTAL function or if you have Excel 2010 use the AGGREGATE function.
Kevin
Quote:
Originally Posted by CJH
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
|