“How do you get the number of results in a given range from a large number of cells. For example, I have a big clump of data and calculations with all the final results for each set in the last column. I want to know, say, the number of final results that were between 1 and 10. How is this achieved.”

Answer from ClaudioFaria

“You can do that with Excel’s COUNTIF function.

It takes two arguments: the range you want to evaluate; and the condition, usually as a string.

Let’s say your results are in column G. Examples:

* =COUNTIF(G:G,”<=10") This counts how many cells is G:G are numerical with values up to 10.

* =COUNTIF(G:G,”<=10")-COUNTIF(G:G,"<1") This counts how many cells is G:G are numerical with values between 1 and 10.

See Excel help. You may be interested in SUMIF function too. For more powerful, and complex, operations on multiple cells, Array Formulas may be needed.”

Got a better answer? Post it in the discussion that generated this tip.