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

F

Fudgy

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?
 
P

Peo Sjoblom

Try

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


where A8 is the cell with 242

copy down


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count if dates meet certain criteria 10
Count unique distinct values that meet multiple criteria 1
"counting" number of entries 2
Formula (or code) return the largest number of duplicates in a list. 16
Sumproduct - meet multiple criteria from a list 6
count the number of rows with entries greater than zero 1
How do I count the number of items that meet 2 criteria? 5
Function in Excel to count and list number of entries of text valuesin a row. 2

Top