Excel help!!

[CptKipling]

Can anyone tell me how to count the zero\'s in a list of numbers like this (in individual cells):

3 2 1 0 7 4 0 1 0....... or whatever.

Intelligent answers only please, this is driving me crazy.

[belgareth]

From Excel help. Let me know if you need more specific info.

COUNT


Counts the number of cells that contain numbers and also numbers within the list of arguments. Use COUNT to get the number of entries in a number field that\'s in a range or array of numbers.

Syntax

COUNT(value1,value2,...)

Value1, value2, ... are 1 to 30 arguments that can contain or refer to a variety of different types of data, but only numbers are counted.

Remarks

Arguments that are numbers, dates, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored. If you need to count logical values, text, or error values, use the COUNTA function.
Example

The example may be easier to understand if you copy it to a blank worksheet.

How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.


Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.


1
2
3
4
5
6
7
8
A
Data
Sales
12/8/2008

19
22.24
TRUE
#DIV/0!
Formula Description (Result)
=COUNT(A2:A8) Counts the number of cells that contain numbers in the list above (3)
=COUNT(A5:A8) Counts the number of cells that contain numbers in the last 4 rows of the list (2)
=COUNT(A2:A8,2) Counts the number of cells that contain numbers in the list, and the value 2 (4)

[CptKipling]

Thanks belgareth that helped a lot.

After reading that I realised i should have just asked \"how do i count how many are not zeros, which is what i really needed.

I did that, but then found that the \"COUNTIF\" function is more usefull to me in this case.

Thanks again

[Lucky]

I was under the impression there would be no math on the forum. /ubbthreads/images/graemlins/grin.gif

[belgareth]

There isn\'t. I can\'t add, that\'s why I got into computers. They do it for me.

[Lucky]

That\'s smart.

[Xehupatl]

10010101010000101110011010100101011010101010000101 01101001010110011010101010010010101010101001001010 10100010101001011001010101000010111001101010010101 10101010100001010110100101011001101010101001001010 10101010010010101010001010100101100101010100001011 10011010100101011010101010000101011010010101100110 10101010010010101010101001001010101000101010010110 01010101000010111001101010010101101010101000010101 10100101011001101010101001001010101010100100101010 10001010100101100101010100001011100110101001010110 10101010000101011010010101100110101010100100101010 10101001001010101000101010010110010101010000101110 01101010010101101010101000010101101001010110011010 10101001001010101010100100101010100010101001011001 01010100001011100110101001010110101010100001010110 10010101100110101010100100101010101010010010101010 00101010010110010101010000101110011010100101011010 10101000010101101001010110011010101010010010101010 10100100101010100010101001011001010101000010111001 10101001010110101010100001010110100101011001101010 10100100101010101010010010101010001010100101100101 01010000101110011010100101011010101010000101011010 01010110011010101010010010101010101001001010101000 10101001011001010101000010111001101010010101101010 10100001010110100101011001101010101001001010101010 10010010101010001010100101100101010100001011100110 10100101011010101010000101011010010101100110101010 10010010101010101001001010101000101010010110010101 01000010111001101010010101101010101000010101101001 01011001101010101001001010101010100100101010100010 10100101100101010100001011100110101001010110101010 10000101011010010101100110101010100100101010101010 01001010101000101010010110010101010000101110011010 10010101101010101000010101101001010110011010101010 0100101010101010010010101010001010100101

[belgareth]

I couldn\'t have said it better myself.

[Xehupatl]

thanks!
we could do a song about that! fire up that midi-music and let\'s sing!
\"one-zero-zero-one-one-zero-zero-etc.\"

/ubbthreads/images/graemlins/grin.gif