=COUNTIF(B2:B30, "Apple")

來源: 於 2007-07-09 19:05:00 [舊帖] [給我悄悄話] 本文已被閱讀：次

Under AppTotal, enter the function. B2:B30 is the range. Use the same way for Orange .....