Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Arrays
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) |