Bienvenido: Ingresar
location: EjemplosPlanilla

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,

None: EjemplosPlanilla (última edición 2010-06-09 18:09:03 efectuada por TiN)