EXCEL
甯哥敤鍑芥暟鍏紡澶у叏鍙婁妇渚?/p>
涓�銆佺浉鍏虫蹇?/p>
锛堜竴锛夊嚱鏁拌娉?/p>
鐢卞嚱鏁板悕
+
鎷彿
+
鍙傛暟缁勬垚
渚嬶細
姹傚拰鍑芥暟锛?/p>
SUM
锛?/p>
A1,B2,
鈥?/p>
)
銆傚弬鏁颁笌鍙傛暟涔?/p>
闂寸敤閫楀彿鈥?/p>
,
鈥?/p>
闅斿紑
锛堜簩锛夎繍绠楃
1.
鍏紡杩愮畻绗︼細鍔狅紙
+
锛?/p>
銆佸噺锛?/p>
-
锛?/p>
銆佷箻锛?/p>
*
锛?/p>
銆侀櫎锛?/p>
/
锛?/p>
銆佺櫨鍒嗗彿锛?/p>
%
锛?/p>
銆佷箻骞傦紙锛撅級
2.
姣旇緝杩愮畻绗︼細澶т笌锛?/p>
>
锛?/p>
銆佸皬浜庯紙
<
锛?/p>
銆佺瓑浜庯紙
=
锛?/p>
銆佸皬浜庣瓑浜庯紙
<=
锛?/p>
銆佸ぇ浜庣瓑浜?/p>
锛?/p>
>=
锛?/p>
銆佷笉绛変簬锛?/p>
<>
锛?/p>
3.
寮曠敤杩愮畻绗︼細鍖哄煙杩愮畻绗︼紙锛?/p>
锛?/p>
銆佽仈鍚堣繍绠楃锛?/p>
,
锛?/p>
锛堜笁锛夊崟鍏冩牸鐨勭浉瀵瑰紩鐢ㄤ笌缁濆寮曠敤
渚嬶細
A1
$A1
閿佸畾绗?/p>
A
鍒?/p>
A$1
閿佸畾绗?/p>
1
琛?/p>
$A$1
閿佸畾绗?/p>
A
鍒椾笌绗?/p>
1
琛?/p>
浜屻�佸父鐢ㄥ嚱鏁?/p>
锛堜竴锛夋暟瀛﹀嚱鏁?/p>
1.
姹傚拰
=SUM
锛堟暟鍊?/p>
1,
鏁板�?/p>
2,
鈥︼級
2.
鏉′欢姹傚拰
=SUMIF
锛堟煡鎵剧殑鑼冨洿
,
鏉′欢
(
鍗冲璞?/p>
),
瑕佹眰鍜岀殑鑼冨洿锛?/p>
渚嬶細
锛?/p>
1
锛?/p>
=SUMIF(A1:A4,
鈥?/p>
>=200
鈥?/p>
,B1:B4)
鍑芥暟鎰忔�濓細瀵圭
A1
鏍忚嚦
A4
鏍忎腑锛屽ぇ浜庣瓑浜?/p>
200
鐨勬暟鍊煎搴旂殑绗?/p>
B1
鍒楄嚦
B4
鍒椾腑鏁板�兼眰鍜?/p>
锛?/p>
2
锛?/p>
=SUMIF(A1:A4,
鈥?/p>
<300
鈥?/p>
,C1:C4)