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.

Attached Files

Budget Table.docx (21.5 KB, 13 views)

I would probably use Excel for this.

I would use more meaningful bookmarks.

I can't figure out what is wrong with your formulas, though. They look correct. I get your anomalous results.

I refer you to MacroPod (Paul Edstein)'s treatise:
Microsoft Word Field Maths Tutorial