Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > General Discussions > General
Register

Reply
 
LinkBack Thread Tools
Old 03.03.2005, 14:51   #1
4294967296
 
Boyov's Avatar
 
Join Date: 03 2002
Location: /proc/1
Age: 33
Posts: 379
Downloads: 4
Uploads: 0
Reputation: 0 | 0
Default Problema s Excel (nujna pomosh')

Privet,

Kak v MS Excel-e napisat' forumlu po kotoroy budet schitat'sya kolichestvo nenulevix elementov v stroke.

Spasibo.

P.S. Eto ochen' srochno
Reply With Quote
Old 03.03.2005, 14:54   #2
Banned
 
DaNYer's Avatar
 
Join Date: 10 2002
Location: Brooklyn, New York
Age: 39
Posts: 3,760
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

COUNTIF
See Also

Counts the number of cells within a range that meet the given criteria.

Syntax

COUNTIF(range,criteria)

Range is the range of cells from which you want to count cells.

Criteria is the criteria in the form of a number, expression, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples".

Remark

Microsoft Excel provides additional functions that can be used to analyze your data based on a condition. For example, to calculate a sum based on a string of text or a number within a range, use the SUMIF worksheet function. To have a formula return one of two values based on a condition, such as a sales bonus based on a specified sales amount, use the IF worksheet function. Learn about calculating a value based on a condition.

Examples

Suppose A3:A6 contain "apples", "oranges", "peaches", "apples", respectively:

COUNTIF(A3:A6,"apples") equals 2

Suppose B3:B6 contain 32, 54, 75, 86, respectively:

COUNTIF(B3:B6,">55") equals 2
Reply With Quote
Old 03.03.2005, 15:02   #3
4294967296
 
Boyov's Avatar
 
Join Date: 03 2002
Location: /proc/1
Age: 33
Posts: 379
Downloads: 4
Uploads: 0
Reputation: 0 | 0
Default

spasibo
Reply With Quote
Old 03.03.2005, 15:05   #4
Banned
 
DaNYer's Avatar
 
Join Date: 10 2002
Location: Brooklyn, New York
Age: 39
Posts: 3,760
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

vsegda pojaluista.
Reply With Quote
Sponsored Links
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 15:43.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.