Column/Row references in Formulae
From
dpb@21:1/5 to
All on Sun Mar 18 14:25:08 2018
The MS Help says the following:
RnCn references
You can refer to a table row, column, or cell in a formula by using the
RnCn reference convention. In this convention, Rn refers to the nth row,
and Cn refers to the nth column. For example, R1C2 refers to the cell
that is in first row and the second column. The following table contains examples of this reference style.
To refer to… …use this reference style
An entire column Cn
An entire row Rn
...
How does the syntax for referring to an entire column actually work in practice; no examples are given.
I have a table with two columns of numbers (for brevity in overall table
height the table is two sets of dates/values side-by-side instead of one
really long one) and want to include the Total of values in both columns
but the two subtotals are immaterial. For specifics, the table is like
Text Date Value Text Date Value
... ... ... ... ... ...
and it's the Value columns that need adding.
=SUM(C3)+SUM(C6)
is interpreted as the two cells; no other syntax I can try will
reference the total values of the 3rd and 6th columns as the doc implies.
It's obviously possible to write
=SUM(C1:C10)+SUM(F1:F10)
but that's inflexible if height of table is changed.
Obviously I must be misreading what the document means for the total
column/row addresses but I can't find any examples and no variations
I've tried seem to work.
=SUM("C3")
=SUM('C3')
Oh! Let's try
=SUM(C:C)
Ah, joy ensues! That doesn't seem to look anything at all like the
documented syntax, however, so that ? still remains...
--
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)