Summing a worksheet with Subtotals

I have a worksheet with roughly 1000 rows and about 20 subtotals of departments within the 1000 rows.

How can I easily total the 1000 rows, or 20 subtotals?

=SUM(A1:A1020)/2 would be one way.

Good one, also when I performed the subtotal, it totaled automatically, with =SUBTOTAL(9,K2:K163).

What does the 9 represent?

Subtotal encompasses a range of functions, 9 represents the sum function. To see them all, type =Subtotal( in the function bar and the drop-down help should give you a list of options denoted by numbers.

If you used the actual Subtotal tool, then there should be a grand total at the end. Otherwise, if you used the Subtotal worksheet function in a formula, then you can use the same formula, but for the range select the entire range the list encompasses, including the other subtotals. The total will ignore all of the other subtotals.

For example, if your data is in A1:A100, and you have subtotals throughout this range, you can still use:

=SUBTOTAL(9,A1:A100)

and it will ignore the other subtotals.

HTH

Jason