Count the number of values in a list that meet certain criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fudgy - 05 May 2008 21:11 GMT

I would like to count the number of values that are greater than a cell
reference value. For example I have the following list in a spreadsheet:
242
318
743
426
174
397
108
75
And would like to compare the following numbers to see how many numbers in
the first list are greater than each of the numbers in the list below:
242
218
194
169
145
121
97
73
48
24
in other words there are 4 numbers in the first list greater than 242 in the
second list.
I can do this by the following formula:
=COUNTIF(G8:G17,">=242")
but it means manaually changong the formula each time with the number in the
second list e.g. 242, 218 etc.
I would like to automate this so I don't have to manually make these changes.
How do I do this as I have over 30 lists each with 10 values to compare?

Reply to this Message

Peo Sjoblom - 05 May 2008 21:23 GMT

Try

=COUNTIF($G$8:$G$17,">="&A8)

where A8 is the cell with 242

copy down

Signature

Regards,

Peo Sjoblom

>I would like to count the number of values that are greater than a cell
> reference value. For example I have the following list in a spreadsheet:
[quoted text clipped - 29 lines]
> changes.
> How do I do this as I have over 30 lists each with 10 values to compare?

Reply to this Message