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!!