Count values in cell when value is dependent upon value in cell another

Tennisguuy

Well-known Member
Joined
Oct 17, 2007
Messages
550
Office Version
  1. 2016
Platform
  1. Windows
I am having a problem trying to count the values in a column when the value I want to count is greater than or equal to a value in another cell. For example in cell J5 I have the value of 70 and in column G13:G207 I want to count the times the values in column G13:G207 is greater than or equal to 70.

The problem is the value in J5 will change based upon the value the user inputs in J5. Therefore I will not always know what that value is.

I tried this formula =Countif($G$13:$G$207,J5) and it worked if I didn't want to use greater than or equal to. If the value in J5 was never going to change I know I could use this formula =countif($G$13:$G$207,">=70"). The problem I am having is the value can change.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,298
Office Version
  1. 365
Platform
  1. Windows
Unless I'm missing something here, I think you just need the proper syntax for function COUNTIF; you need the &. Like this: =COUNTIF($G$13:$G$207,">="&J5)
 
Last edited:

Tennisguuy

Well-known Member
Joined
Oct 17, 2007
Messages
550
Office Version
  1. 2016
Platform
  1. Windows
Thanks that worked perfectly. Much appreciated.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,543
Messages
5,529,456
Members
409,879
Latest member
Aussie_Excel_Wanna_Be
Top