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.
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
PS please don't use abbreviations such as ppl - it makes it harder to understand what you want to do specifically.