I am an old math student from way back when but have not used anything higher than say Algebra for years. Did very well in math in college but pursued another line of study - Information Systems.
Here is my problem:
I want to determine the entire value of a set of cells contained within a matrix that I determine based on dimensions.
Each column of values is the same. In the first column all values are "2." All cells in the next columns will be +1 of the cells preceding column.
Thus the values for column 1 are 2, Column 2 are 3, Column 3 are 4 and so on.
Thus if I set the dimensions of the array of values to be x=10 and y=10 then the 10th column cell values will be worth 11 each.
Is there a formula that applies to this?
z=total value of all cell values in the array.
cell value =2 for row 1 and +1 for each row thereafter.
total = 56
Thus the function of x is to determine the amount of similar cell values in a particular column.
The function of y is to determine the amount of columns in the array.
Is this something that can be solved here or should I look for a programmer?