Hi Paul

I have split my tables and now the subtotals show 0.0

My biggest problem with the row formula was correct cell address. I used the macro "CellAddress" in the Maths tutorial to find the correct row numbers and now it's all working correctly.

I know now what you mean by preferring Excel for this. Is there a simple way to convert a Word document into an Excel document?