³ .
, A1.
, , .
( C2 D11), E2 E11 :
=C2:C11*D2:D11
Ctrl+Shift+Enter.
({ }) . ,
A13 .
B13 Ctrl+Shift+Enter.
=SUM(C2:C11*D2:D11)
Excel ( C2 D11), SUM . 111 800 $. , . , 15 000 . , .
, ( B13) ( E2 E11). . - , , .
:
. - 2, . .
. . , E3 Delete. (2 11) . Ctrl+Shift+Enter, , .
. . , , , . (, =C2*D2), 11 .
. (=) Excel. , Ctrl+Shift+Enter. ϳ Excel . , .
|
|
, . , , , :
=C2*D2
=C3*D3
B13 , 䳿, : =E2+E3+E4 .
: Ctrl+Shift+Enter , . .
, :
ij , , , . 3 , E2 E11.
. , 3 Delete.
, . , , .
, (, =C2:C11*D2:D11), Delete, Ctrl+Shift+Enter.
. .
( ). , .
- , .
, A12. , , . 6 2500
7 1900
4 2200
3 2000
8 2300
8 2100
, (E2:E11), (E12:E17), . , E2:E17.
F2, .
C11 C17, D11 D17, Ctrl+Shift+Enter. Excel E2 E11 (E12 E17).
:
Ctrl+Shift+Enter. , . .
. , , , , , .
.