Maybe you can post the fomrula that is erroneous?

--

Regards,

Peo Sjoblom

"Tobro88" wrote in
message ...


I have created a spreadsheet that contains the names and demographic
data for children and their scores on a state test. I am trying to use
an array to count how many children fall into each category that I have
set up based on percentages. When I create the array, it does not
count the number 0 in any of my totals. The only way that I have
discovered that I can get 0s counted is to modify the formula to count
0.1 as 0. Any idea how to include zeros in an array?

If I can get this to work, I will begin breaking things down by gender,
ethnicity, etc. If anyone knows of an easier way to do all of this, let
me know!!
Thanks!!
:)


--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile:
http://www.excelforum.com/member.php...o&userid=28895
View this thread: http://www.excelforum.com/showthread...hreadid=486415