Hi,

Actually the 9 means two things:

1. The operation you want to perform is SUM
and
2. The entries you want to sum are hidden via the AutoFilter command, not
by manually hidding the rows or collapsing groups (as in the Subtotal
command).
3. If you want to sum only visible cells choose 109 instead of 9. Then it
doesn't matter how you hide the rows.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Deborah" wrote:

What does the 9 in this formula mean "=SUBTOTAL(9,J2:J105)"?