Hello,  

I am learing how to use infopath form 2007, I am stumped on the math formulas for the form that I am creating.  I have 8 repeating tables that includes a dropdown list of different codes in the first column, second is a name box and the third  is to include dollar amt. My question is can the repeating tables look for the subtotals in its own box?  The blue group is the repeating tables with 3 columns labeled in pink.

The colors are color coordinated to show you what is totaled. it is straight forward adding in each section. Can this all be done separately since I have up to 8 repeating tables?  Please help and thank you for your time.

 
BUILDING SQUARE FOOTAGE:  

Building   Section 1
csi code                                      Sub-Contractor Name                          Bid Amount
 SITE  
02-260 CLEARING AND GRUBING  
02-300 EARTHWORK  
CONCRETE    
03-050 FOUNDATION AND SLAB  
03-050 SIDEWALKS BUILDING  
 MASONRY  
04-210 CMU  
04-400 CAST STONE  
SUB-TOTAL BUILDING   -  

General Conditions  Section 2
csi code                                 Bid Amount
01-140 PERMITS  
01-150 TAPS AND FEES  
SUB-TOTAL - GENERAL CONDITIONS   -  
 
Totals Section 3
TOTAL PROJECT  (sum of the subtotal building)-  
TOTAL GEN COND(sum of the subtotal Gen Conditions)  -  
SUB-TOTAL   -   Total of both project and gen cond -
 
 
CENTRAL EXPENSE / INSURANCE  -
FEE  
SALES TAX  

PROJECT TOTAL   $- Sum of ( SubTotal,  CENTRAL EXPENSE / INSURANCE , FEE , SALES TAX )
Square Foot Cost - (BUILDING SQUARE FOOTAGE (at top) / PROJECT TOTAL)