- EXAMPLE:
SUM over columns
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
RESULT:
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
cell B1 no data
A |
B |
C |
D |
1.00 |
|
2.00 |
3.00 |
RESULT:
A |
B |
C |
D |
1.00 |
2.00 |
3.00 |
SUM over rows
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
RESULT:
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
SUM over rows and columns
A |
B |
C |
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
RESULT:
A |
B |
C |
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
-column_header
A |
B |
1.00 |
2.00 |
3.00 |
4.00 |
5.00 |
6.00 |
RESULT:
A |
B |
1.00 |
2.00 |
3.00 |
4.00 |
5.00 |
6.00 |
-row_header
0 |
1.00 |
2.00 |
1 |
3.00 |
4.00 |
2 |
5.00 |
6.00 |
RESULT:
0 |
1.00 |
2.00 |
1 |
3.00 |
4.00 |
2 |
5.00 |
6.00 |
-column_header -row_header
|
A |
B |
0 |
1.00 |
2.00 |
1 |
3.00 |
4.00 |
2 |
5.00 |
6.00 |
RESULT:
|
A |
B |
0 |
1.00 |
2.00 |
1 |
3.00 |
4.00 |
2 |
5.00 |
6.00 |
-show_formular -column_header -row_header
|
A |
B |
0 |
'm' |
'p' |
1 |
1 |
a1 * 5 |
2 |
2 |
a2-3 |
3 |
3 |
4 |
RESULT:
|
A |
B |
0 |
m |
p |
1 |
1 |
=A1*5 |
2 |
2 |
=A2-3 |
3 |
3 |
4 |
-column_header and blanks in cells
A |
B |
C |
D |
E |
F |
Name Vorname |
|
|
3.00 |
|
5.00 |
Name Vorname |
1.00 |
2.00 |
|
4.00 |
5.00 |
Name Vorname |
1.00 |
2.00 |
|
|
5.00 |
RESULT:
A |
B |
C |
D |
E |
F |
Name Vorname |
|
|
3.00 |
|
5.00 |
Name Vorname |
1.00 |
2.00 |
|
4.00 |
5.00 |
Name Vorname |
1.00 |
2.00 |
|
|
5.00 |
-format 1,1
1.0 |
2.0 |
3.0 |
4.0 |
4.0 |
16.0 |
RESULT:
1.0 |
2.0 |
3.0 |
4.0 |
4.0 |
16.0 |
{{{ useage of variable names -show_formular -column_header -row_header }}}
|
A |
B |
C |
0 |
'A' |
'B' |
'C' |
1 |
1 |
2 |
a1+two |
2 |
10 |
20 |
sum('a2:b2') |
3 |
sum('a1:a2') |
sum('b1:b2') |
sum('c1:c2') |
RESULT:
|
A |
B |
C |
0 |
A |
B |
C |
1 |
1 |
{two}2 |
=A1+two |
2 |
10 |
20 |
=@sum(A2:B2) |
3 |
=@sum(A1:A2) |
=@sum(B1:B2) |
=@sum(C1:C2) |
and if we calculate BR RESULT:
|
A |
B |
C |
0 |
A |
B |
C |
1 |
1.00 |
2.00 |
3.00 |
2 |
10.00 |
20.00 |
30.00 |
3 |
11.00 |
22.00 |
33.00 |
{{{color in cells }}}
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
RESULT:
A |
B |
C |
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
{{{delimit input with ',' }}}
A |
B |
1.00 |
2.00 |
3.00 |
4.00 |
5.00 |
6.00 |
RESULT:
A |
B |
1.00 |
2.00 |
3.00 |
4.00 |
5.00 |
6.00 |
{{{delimit input and output with ',' }}}
,''' ''','''A''','''B''', ,'''0''', 1.00, 2.00, ,'''1''', 3.00, 4.00, ,'''2''', 5.00, 6.00,
RESULT:
,''' ''','''A''','''B''', ,'''0''', 1.00, 2.00, ,'''1''', 3.00, 4.00, ,'''2''', 5.00, 6.00,