Form field calculation returning 2x correct result

[Jschueller]

Hi and thanks for reading,

I'm new to working with this type of field/calculation so please bare with me if I'm making an obvious mistake. I've attached a table containing some calc fields (Columns E & G, and all rows in bold) that are not working as I expect. Protection is not enforced in order to allow a look at the field formatting, though it is when the table is in use.

Column G is the sum of columns E & F, but the calculation somehow is doubling the amount in column E. The same occurs in each bold row (sub and grand totals). For example, "personnel total" should be a sum of the amount for each itemization, but in column G it is double the sum.



What am I doing wrong? I can't seem to figure it out. Thanks!

BTW, Windows 7 and Word 2010.