title: Excel VBA: Summing rows and columns
body: <p>Very new to VBA and working on a project. I have a file that contains sales data for 1000 products (rows) across 50 days (columns).</p>
  
  <p>In the last column, I want to display the total sums for each product across each day. What is the best way to accomplish this? Should I do a for-next loop?</p>
  
  <p>This is what I have so far: </p>
  
  <pre><code>Sub testsum()
  
  Worksheets("Sheet1").Range("BJ1") = "Sum"
  
  Range("BJ2:BJ1001").Value = Application.WorksheetFunction.Sum(Range("B2:BI1001"))
  
  End Sub
  </code></pre>
  
  <p>I know this isn't right because I am getting the sum of sales for all 1000 products for 50 days vs. only getting the sum of each product (Row) for all days.</p>
  
  <p>Hope I wasn't confusing in explaining. Thanks!</p>