幫幫忙(excel問題)

2007-05-23 9:00 pm
excel的一個column 裏..有很多個A、B、C等..
如果想統計將那行的物品A有多少個,請問那個formula是甚麼...

回答 (4)

2007-05-23 9:26 pm
✔ 最佳答案
I THINK YOUR QUESTION IS IF THE DATA IN YOUR COLUMN ARE AS FOLLOWS:
AND YOU WISH TO KNOW HOW MANY A IN THIS COLUMN, THEN THE FORMULA WOULD BE =COUNTIF(YOUR RANGE, "A")

HOPE IT CAN SOLVE YOUR PROBLEM.

A
A
A
B
B
C
C
A
B
A
A
C
B
B
B
B
B
B
B
B
2007-05-23 10:24 pm
@SUM(A1 :A........)

另可參考以下綱址,可教你所有EXCEL 用法.
2007-05-23 9:18 pm
=sum(行數開頭:行數結尾)
eg:=sum(A1:A3)

或者有個簡單d既方法
excel工具欄有個好像 'E' 字的算項 ( 在a-z排序的左邊)
先找一個空白的格(你想計算總數結果出現的位置)
然後按一下個 'E' 字,再由你想計算總數的開頭拉到計算結尾,然後按enter就ok

好像有d複雜,不過學識後就會好方便^^

2007-05-23 13:18:55 補充:
是選項,不是算項,打錯了@@
2007-05-23 9:05 pm
=sum(A1:A10)
參考: me


收錄日期: 2021-04-12 20:22:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070523000051KK01252

檢視 Wayback Machine 備份