Home

COUNT IF Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-736447%22%20slang%3D%22en-US%22%3ECOUNT%20IF%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20am%20trying%20to%20create%20a%20a%20count%20if%20with%20the%20below%20criteria%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E1)%20Customer%20name%20(column%20A)%20is%20a%20duplicate%2C%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2)%20The%20value%20in%20column%20B%20is%20greater%20than%2090%25%20of%20the%20original%20entries%20value%20in%20column%20B%2C%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E3)%20The%20value%20in%20column%20B%20is%20less%20than%20110%25%20of%20the%20original%20entries%20value%20in%20column%20B.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20in%20advance%20for%20any%20help%2C%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-736447%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736607%22%20slang%3D%22en-US%22%3ERe%3A%20COUNT%20IF%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736607%22%20slang%3D%22en-US%22%3EYou%20are%20comparing%20the%20value%20of%20Column%20B%20with%20the%20original%20values%20in%20the%20same%20Column%20B.%20How%20do%20you%20determine%20those%20original%20values%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736611%22%20slang%3D%22en-US%22%3ERe%3A%20COUNT%20IF%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3Bthanks%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20uploaded%20an%20example%20workbook%20to%20try%20and%20illustrate%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20compare%20the%20value%20in%20column%20B%20on%20the%20original%20line%20with%20the%20value%20in%20column%20B%20on%20the%20duplicate%20line.%3C%2FP%3E%3C%2FLINGO-BODY%3E
njones359
New Contributor

Hi, 

I am trying to create a a count if with the below criteria:

1) Customer name (column A) is a duplicate, 
2) The value in column B is greater than 90% of the original entries value in column B, 
3) The value in column B is less than 110% of the original entries value in column B. 

Thanks in advance for any help,

2 Replies
You are comparing the value of Column B with the original values in the same Column B. How do you determine those original values?

@Twifoo thanks for your help.

 

I have uploaded an example workbook to try and illustrate this.

 

I am looking to compare the value in column B on the original line with the value in column B on the duplicate line.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies