Brother International PN-5700DS Owner's Manual - English - Page 119
Suma1..b3
![]() |
View all Brother International PN-5700DS manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 119 highlights
pulled up (to the left) and any moved formula is updated. Example 1: 1. Enter the data shown below in the range Al ..B3, then enter the formula @SUM(A1..B3) in cell C5. is @SUM(Al..63) PITCH:10 6 1 4 2 5 3 6 2. Now delete row 2. To recalculate the results, refer to "Recalculation" on page 116. 4 @SUM(Al..B2) PITCH:10 A 4 3 6 • When a function is defined on a range, like in the above example, you are not allowed to delete a row or a column that contains a corner of the range. Example 2: 1. Using the same initial data as in the above example, delete row 1. @SUM(?..B2) A a PITCH:10 2 5 3 6 3 SPREADSHEET 105
![](/manual_guide/products/brother-international-pn5700ds-owners-manual-english-0f8248a/119.png)
pulled
up
(to
the
left)
and
any
moved
formula
is
updated.
Example
1:
1.
Enter
the
data
shown
below
in
the
range
Al
..B3,
then
enter
the
formula
@SUM(A1..B3)
in
cell
C5.
is
@SUM(Al.
.63)
6
1
4
2
5
3
6
PITCH:10
2.
Now
delete
row
2.
To
recalculate
the
results,
refer
to
"Recalculation"
on
page
116.
4
@SUM(Al.
.B2)
A
4
3
6
PITCH:10
•
When
a
function
is
defined
on
a
range,
like
in
the
above
example,
you
are
not
allowed
to
delete
a
row
or
a
column
that
contains
a
corner
of
the
range.
Example
2:
1.
Using
the
same
initial
data
as
in
the
above
example,
delete
row
1.
@SUM(?..B2)
A
2
3
3
a
5
6
PITCH:10
SPREADSHEET
105