The following syntax should be used in calculations for four row or column:
 
For Columns:
  • Format for summation of a column range: {c1:c5} = Sum of column 1 through 5.
  • Format for adding columns: {c1}+{c2}+{c3} = column 1 + column 2 + column 3.
  • Format for subtracting columns: {c1}-{c2}-{c3} = column 1 - column 2 - column 3.
For Rows:
  • Format for row ranges: {r1:r5} = Sum of row 1 through 5.
  • Format for adding rows: {r1}+{r2}+{r3} = row 1 + row 2 + row 3.
  • Format for subtracting to rows: {r15}-{r21} = row 15 - row 21.
  • Performing multiple calculations on a row: ({r15}-{r21})/{r15} = (row 15 - row 21)/row 15.

ASU-banner-4.jpg

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.