title: sum of a range in vba
body: <p>say , I have a data like below in one sheet,</p>
  
  <pre><code>Name        Date    time 1   time 2  time 3 time 4  
  DA_BAB      02/11/2019   6        1       0      1
  DA_GMO      02/11/2019   4        3       5      0 
              02/11/2019   1        2       1      1 
  DA_GMO      02/11/2019   2        1       1      4 
  Lloyd       02/11/2019   0        2       0      0
  </code></pre>
  
  <p>I had to group according to name and sum all the time under one category in vba .</p>
  
  <p>eg DA_BAB  is 8 and Lloyd is 2 and so on.</p>
  
  <p>I am really new to vba and do not know how to write this .Could anyone help me?</p>
  
  <p>I tried to create a function and call that function, but it did not work </p>
  
  <p>when we group data we should get like below </p>
  
  <p>DA_BAB  is 8 and Lloyd is 2 and so on.</p>