Arrays
:confused: 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 |
Arrays
Maybe you can post the fomrula that is erroneous?
-- Regards, Peo Sjoblom "Tobro88" wrote in message ... :confused: 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 |
Arrays
Tobro88 Wrote: :confused: 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!! :) Hi Tobro88 I don't know about 0's in an array, but another way to get the results you want would be to use a pivot table -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=486415 |
Arrays
This is the formula that I am usimg to list all of the kids that scored in the range 0-3. =SUM((E2:E26=0)*(E2:E26<=3)) For some reason it is not counting the zeros unless I create it the following way: =SUM((E2:E26=0.1)*(E2:E26<=3)) and then format the colum to round down. I may try the pivot table idea, but I was hoping to avoid that. Thanks!! -- Tobro88 ------------------------------------------------------------------------ Tobro88's Profile: http://www.excelforum.com/member.php...o&userid=28895 View this thread: http://www.excelforum.com/showthread...hreadid=486415 |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com