×
英语
很抱歉。本文没有你的语言版本。

Count numbers greater than or less than a number

Let's say you are preparing a report, and you want to count how many sales invoices were greater or lesser than a particular value. Use the COUNTIF function to count numbers greater than or less than a number.

COUNTIF examples

A11 and A12 has formulas where COUNTIF checks for the number of invoices less than 20000 and greater than or equal to 20,000 in the B2:B7 range. COUNTIF finds 4 values less than 20000 and 2 values greater than and equal to 20000.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×