Microsoft Excel 2003 (full product)

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

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

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

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:01Regarding the analysis of the data:

you said12+13+14+15(including 15) =54, but you also said

so value=4 (4item)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 resultsRegards

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

Ask Your Question

Weekly Poll

Do you think Samsung's Bixby will compete well against other phone AI systems?

Discuss in The Lounge

Poll History