幫幫忙(excel問題)

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

@SUM(A1 :A........)

另可參考以下綱址,可教你所有EXCEL 用法.

=sum(行數開頭:行數結尾)
eg:=sum(A1:A3)

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

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

2007-05-23 13:18:55 補充：
是選項,不是算項,打錯了@@

=sum(A1:A10)