Urgent!Cell Counting

Microsoft Excel 2003 (full product)
August 16, 2010 at 11:26:28
Specs: Windows XP
Hello everyone!
my problem is that
I have 46 cells which each of them contain a value,say 5,6,7,8,9..
My target is to know how many cells there are which sum of these cell is less than a specific value ,say 50.and how many cells there are which sum of these cells is between two value, say >50 <100.
Example:
12 13 14 15 16 17 18 12 20
since
12+13+14+15(including 15) =54
so value=4 (4item)
then 54+ (16+17+18)=105
so value=3 (3 item 16,17,18)
thanks a lot

See More: Urgent!Cell Counting

Report •


#1
August 16, 2010 at 11:39:15
Hi,

Sounds like a course project.

If you have come up with some formulas and they are not working as expected, post what you have done, and someone will be able to suggest what you need to do to get the required answers.

Regards


Report •

#2
August 16, 2010 at 12:29:16
in fact i hv done nothing yet
i am doing a task for my fd..
people hv done 46 question
every question have a time(second)
he want to know average in 5 minute 5 to 10 min and ten to 15 min
how many question ppl can done

Report •

#3
August 17, 2010 at 04:25:08
Hi,

Not quite clear about your data.

Do you have only 46 cells with data as you originally said,
or do you have a series of 46 cells containing data and each series of 46 is for a different person. (people hv done 46 question ... you appear to be referring to people rather than one person)

You say that every question have a time(second)
Does this mean that the data is in seconds. For example if it took 61 seconds to complete a question would the value be 61 or would it be in an Excel time format like this: 1:01

Regarding the analysis of the data:
you said 12+13+14+15(including 15) =54
so value=4 (4item)
, but you also said My target is to know how many cells there are which sum of these cell is less than a specific value ,say 50.and how many cells there are which sum of these cells is between two value, say >50 <100.
I can't work out what this means. If you have 12, 13, 14, the sum of these cells is 39. This meets the 'criteria' of Sum of these cells is less than 50 (50 is less than 39) - but how do you select the cells that contain 12, 13 & 14.
or
did you mean that there are cells containing 12, 23 & 49 and all of these cells are less than 50. Then work out the average (28)

In response number 2 you say he want to know average in 5 minute 5 to 10 min and ten to 15 min how many question ppl can done
How does this relate to the original request: My target is to know how many cells there are which sum of these cell is less than a specific value ,say 50.

Can you let us know how the data is laid out on the worksheet.
Are results 1 to 46 in columns or rows
Which column or row contains the first data item
If there are results for multiple people, how are these arranged - which cells contain names or ID's, and which cells contain data.

If there are a series of times taken to complete each of 46 questions by a number of individuals, I would look at creating a table of statistics for each person - such as overall average time taken, number of questions completed in less than 5 minutes, 5 to less than 10 minutes and so on, and the proportion (%) of questions completed in each of these defined time bands.
Then I would do a similar table for all individuals - overall how many questions were completed in less than 5 minutes and so on, and proportions (%) completed in each time band.
With both overall results and results per person, I could compare the individual results to the overall results

Regards
PS please don't use abbreviations such as ppl - it makes it harder to understand what you want to do specifically.


Report •

Related Solutions


Ask Question