=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 .....