Hello,
I have a worksheet with just under 700 lines. This worksheet consists of
employees, their department and their payroll life insurance deductions for a
specific pay date. I have grouped them by department and subtotaled the
deductions. Is there a formula that tells excel I want a grand total that
only adds the subtotals (because all values are in one column...I suppose I
could sum and divide by 2?) Actually that works!

Well, I'll leave the post here in case anyone else is trying to get a
solution!

Thanks for giving me a forum to talk out my problem!

Sherry