Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

假設您正在準備報表,而您想要計算有多少銷售發票大於或小於特定值。 使用 COUNTIF 函數計算大於或小於數位的數位。


A11 和 A12 有公式,COUNTIF 會檢查 B2:B7 範圍中小於 20000 且大於或等於 20,000 的發票數目。 COUNTIF 會尋找 4 個小於 20000 的值,以及 2 個大於和等於 20000 的值。

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

How satisfied are you with the translation quality?
What affected your experience?

Thank you for your feedback!