. : http://uneex.lorien.cs.msu.su/static/GnumericDoc_ru/r2434.html
: Mon Sep 26 12:35:55 2011
: Tue Oct 2 07:14:26 2012
: IBM-866

:
COUNTIF

COUNTIF

Name

COUNTIF -- 

Synopsis

COUNTIF(¶̺ʺǶ, ̺Ѷú̶)

Description

ɺ̺ COUNTIF ںӶ̺Ⱥ޶ú Ӷ̺ȶ ޺Ӷöú ºɶɶǶ @¶̺ʺǶɶ ¶ǶȶúѶǺ޺ݺض̺ 溧ɶɶǶͺ @̺Ѷú̺.

Ѻ Ժɺ̺ ǶͶúѶ̶ͺ Excel.

Examples

ǶʺѶ̶, ӺѶ ޺Ӷö˺ A1, A2, ... A5 Ƕ¶ú Ӷ̺Ⱥ 23, 27, 28, 33 39. Ƕº

COUNTIF(A1:A5,"<=28") ɺ޶úѺ 3.

COUNTIF(A1:A5,"<28") ɺ޶úѺ 2.

COUNTIF(A1:A5,"28") ɺ޶úѺ 1.

COUNTIF(A1:A5,">28") ɺ޶úѺ 2.

See also

COUNT, SUMIF.