count if

%3CLINGO-SUB%20id%3D%22lingo-sub-773446%22%20slang%3D%22en-US%22%3Ecount%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773446%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20please%20i%20have%20spreadsheet%20with%20input%20data%20and%202nd%26nbsp%3B%20sheet%20that%20summarize%20the%20data%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20use%20countif%26nbsp%3B%20it%20is%205%25%20lower%20than%20recommended%20but%20seem%20because%20of%20the%20formula%20it%20returns%20to%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0.95%3C%2FTD%3E%3CTD%3E1.05%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EAir%20Pressures%20found%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ERecommended%3C%2FTD%3E%3CTD%3EUnder-Inflated%3C%2FTD%3E%3CTD%3Eover-inflated%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ELow%20Pressure%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E800%3C%2FTD%3E%3CTD%3E760%3C%2FTD%3E%3CTD%3E840%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ENormal%20Pressure%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E650%3C%2FTD%3E%3CTD%3E617.5%3C%2FTD%3E%3CTD%3E682.5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EHigh%20Pressure%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E720%3C%2FTD%3E%3CTD%3E684%3C%2FTD%3E%3CTD%3E756%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-773446%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773459%22%20slang%3D%22en-US%22%3ERe%3A%20count%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773459%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382065%22%20target%3D%22_blank%22%3E%40Marios1%3C%2FA%3E%26nbsp%3B%2C%20which%20exactly%20column%20do%20you%20count%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773476%22%20slang%3D%22en-US%22%3ERe%3A%20count%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTIF('Air%20Pressure'!B7%3AC14%3B%22%26lt%3B%3DJ4%22)%20B7%3Ac14%20-data%20input%20sheet%26nbsp%3B%20J4%26nbsp%3B%20%3D800*.95%20%3D760%20if%20that%20make%20sense%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773523%22%20slang%3D%22en-US%22%3ERe%3A%20count%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773523%22%20slang%3D%22en-US%22%3ETry%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DCOUNTIF('Air%20Pressure'!B7%3AC14%3B%22%26lt%3B%3D%22%26amp%3BJ4)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773820%22%20slang%3D%22en-US%22%3ERe%3A%20count%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773820%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%20Thank%20you%20that%20worked%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Marios1
New 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 :-)