September 24, 2013

Sum values only those which are not hidden

Problem: Sum function sums all values, even though some are not visible (hidden) in Excel

How to sum only visible values - not to include hidden ones -
the instructions for Excel says to use SUBTOTAL instead of SUM and number 9 or 109 in front of the range, like this;


=SUBTOTAL(9,D6:D82)


In Croatian system this doesn't work,
there should be ; instead of ,
and number 109;


=SUBTOTAL(109; A1:A5)