, , . (, ), ( ). :
, , . .
, .
, , .
MS Excel .
2 MS Excel , 2, 2.
2
A 1 : A 1: H 1; ; .
( A) . A 3 1, A 3: A 12.
, , . ( ).
F 3 =(B 3: D 3). F 4: F 12.
G 3 =(E 3=""; F 3;0). G 4: G 12.
. H 3 = G 3/$ F $14 H 4: H 12.
, . .
B 13 =(B 3: B 12) . C 13, D 13 F 13.
B 14 =(B 3: B 12) . C 14, D 14 F 14.
B 15 =(B 3: B 12) . C 15, D 15 F 15.
|
|
, , . B 16 =ר(B 3: B 12;">0"). C 16, D 16.
, , . E 16 =ר(E 3: E 12;"").
, 2.
( 2) . A 3: A 12 F 3: F 12. CTRL. , , 3.
3
, , , ( 2 , , ). A 3: E 12 ( /, , ). ( // ).