Reply to thread

Message: [QUOTE="Dave Peterson, post: 3203518"] How did you create the existing subtotals? Did you use data|subtotals? Or did you use/insert the =subtotal() formulas manually? Or did you use/insert =sum() formulas manually? If you didn't use data|subtotals, I'd remove those manual formulas/rows and use that. Life will be much easier. And you'll get the subtotals and grandtotal, too! If you used =sum() and don't want to get rid of them (yech!!!), you could just add up the total and divide by two. =sum(b2:b999)/2 [/QUOTE]