count if

Copper Contributor

I need help please i have spreadsheet with input data and 2nd  sheet that summarize the data 

i want to use countif  it is 5% lower than recommended but seem because of the formula it returns to 0

 

 

 0.951.05 Air Pressures found 
RecommendedUnder-Inflatedover-inflated Low Pressure0
800760840 Normal Pressure1
650617.5682.5 High Pressure0
720684756   
4 Replies

@Marios1 , which exactly column do you count?

@Sergei Baklan 

 

=COUNTIF('Air Pressure'!B7:C14;"<=J4") B7:c14 -data input sheet  J4  =800*.95 =760 if that make sense

Try this:

=COUNTIF('Air Pressure'!B7:C14;"<="&J4)

@PReagan  Thank you that worked :)