title: Calculate matrix of values based on column and row totals
body: <p>I have data that is broken into group totals (rows) and month totals (columns). I need to take the totals and calculate a value for each month within each group. From my screen shot I can find an monthly cell value for the quarter total with the formula 
  <code>=INT($F3/3)</code>; this would ensure that all rows total correctly but does not address the requirement for all columns to total correctly. </p>
  
  <p>For the screen shot I manually added the values to visualize the desired outcome</p>
  
  <p>Group Calculation: (Jan+Feb+Mar)=Q1 group total</p>
  
  <p>Month Calculation: (Group1...Group6)+Inventory = Monthly Total</p>
  
  <p>In the "current result" screen shot the values total correctly by groups however the result is incorrect by month. For example 'Jan' totals to 159.</p>
  
  <p>Current Result</p>
  
  <p><a href="https://i.stack.imgur.com/tmGAL.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tmGAL.jpg" alt="currentresult"></a></p>
  
  <p>I'm looking for assistance in a formula or vba that would allow the monthly values to total to the group and month total.</p>
  
  <p>Desired Result</p>
  
  <p><a href="https://i.stack.imgur.com/YEVX2.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YEVX2.jpg" alt="CalcBlock"></a></p>