working with arrays

Question

I am working with Visual Basic and i need to Find the total of each column in the last row Find the grand total in the last cell(the bottom right corner). I know how to do the total thing for this class. But this subject I am working with Arrays. I am sure if that will work with the arrays or will it. I need to have a total at the bottom for this. I am not to sure on how to do it. So if maybe someone might have website i can read on about or something I would be happy. Thanks.

Again this is what I am suppose to do:Find the total of each column in the last row Find the grand total in the last cell(the bottom right corner).

Module Module1
Sub Main()

    Dim sum(5, 4) As Integer
    Dim row, col As Integer
    Dim total As Integer
    For row = 0 To 4
        For col = 0 To 3
            sum(row, col) = row + col
            sum(row, 4) += row + col
        Next col
    Next row
    For row = 0 To 5
        For col = 0 To 4
            Console.Write(sum(row, col) & vbTab)
        Next col
        Console.WriteLine()
    Next row

End Sub

End Module

Since you posted a question, it's rather obvious you have a question. Give it a real title. — Don Roby
– Don Roby, Commented Apr 27, 2011 at 11:40
I'm confused on what you're trying to ask; could you elaborate/clarify? — user513638
– user513638, Commented Apr 27, 2011 at 11:42

DarinH · Accepted Answer · 2011-04-27 20:22:04Z

1

One big problem is that you're traversing the array by ROWS then columns.

Doing that, you'll sum up each ROW not each COLUMN.

First step would be to reverse that.

Second, you appear to be storing the col totals on row 4, so you can't step down to row 4, just row 3.

Finally, you appear to be adding the value of the row and col vars, instead of the array entry pointed to by those vars.

Something more like this

   For col = 0 to 3
      for row = 0 to 3
         sum(4, 4) += Sum(row, col)
         sum(4, col) += Sum(row, col)
    ...

edited Apr 27, 2011 at 20:22

answered Apr 27, 2011 at 17:02

DarinH

4,8872 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

working with arrays

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related