I guess that you want it so the hidden values are not included in th
total. If you use =SUBTOTAL(9,"A1:A100") instead of =SUM() this will d
the job. You might even be able to use Data/Subtotals to set this up

--
Message posted from http://www.ExcelForum.com