Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub SumPosValOfMatrix()
  2.     matrixA = CreateMatrix(10, 20)
  3.     matrixB = CreateMatrix(15, 10)
  4.    
  5.     Dim i As Integer, j As Integer
  6.     Dim sum As Single
  7.     sum = 0
  8.    
  9.     For i = 1 To 10 'string_count
  10.        For j = 1 To 20 'column_count
  11.        If matrixA(i, j) > 0 Then
  12.         sum = sum + matrixA(i, j)
  13.         End If
  14.         Next j
  15.         MsgBox ("matrixA: " & vbCrLf & " Сумма положительных чисел в строке " & i & ": " & sum)
  16.         'обнуляем сумму
  17.        sum = 0
  18.     Next i
  19.    
  20.     For i = 1 To 15 'string_count
  21.        For j = 1 To 10 'column_count
  22.        If matrixB(i, j) > 0 Then
  23.         sum = sum + matrixB(i, j)
  24.         End If
  25.         Next j
  26.         MsgBox ("matrixB: " & vbCrLf & " Сумма положительных чисел в строке " & i & ": " & sum)
  27.         'обнуляем сумму
  28.        sum = 0
  29.     Next i
  30.    
  31.    
  32. End Sub
  33.  
  34. Public Function CreateMatrix(string_count As Integer, column_count As Integer)
  35.     Dim i As Integer, j As Integer
  36.     ReDim matrix(1 To string_count, 1 To column_count) As Single
  37.     For i = 1 To string_count
  38.             For j = 1 To column_count
  39.             matrix(i, j) = Rnd() * 200 - 100
  40.             Next j
  41.         Next i
  42.     CreateMatrix = matrix
  43. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement