title: Subtotal using awk for multiple columns
body: <p>with out Excel is that possible to do subtotal for multiple columns using awk for a csv file</p>
  
  <p>File1.txt </p>
  
  <pre><code>Group,Host,1-Dec-14,2-Dec-14,3-Dec-14,4-Dec-14,5-Dec-14,6-Dec-14
  GroupA,HostA,10,20,30,40,50,60
  GroupB,HostB,10,20,30,40,50,60
  GroupA,HostC,10,20,30,40,50,60
  GroupC,HostD,10,20,30,40,50,60
  GroupB,HostE,10,20,30,40,50,60
  GroupC,HostF,10,20,30,40,50,60
  </code></pre>
  
  <p>File with departments:</p>
  
  <pre><code>Group,Host,Dept,1-Dec-14,2-Dec-14,3-Dec-14,4-Dec-14,5-Dec-14,6-Dec-14
  GroupA,HostA,Finance,10,20,30,40,50,60
  GroupB,HostB,HR,10,20,30,40,50,60
  GroupA,HostC,Finance,10,20,30,40,50,60
  GroupC,HostD,HR,10,20,30,40,50,60
  GroupB,HostE,Finance,10,20,30,40,50,60
  GroupC,HostF,HR,10,20,30,40,50,60
  </code></pre>
  
  <p>Result is </p>
  
  <pre><code>Group,Host ,1-Dec-14,2-Dec-14,3-Dec-14,4-Dec-14,5-Dec-14,6-Dec-14
  GroupA Total,,20,40,60,80,100,120
  GroupB Total,,20,40,60,80,100,120
  GroupC Total,,20,40,60,80,100,120
  GrandTotal,,60,120,180,240,300,360
  </code></pre>