Subtotal Function

There's much more to Excel's SUBTOTAL function than meets the eye, such as the ability to only sum visible cells. Refer to Excel's online help for more information.