PROBLEMS WITH COUNTIF

%3CLINGO-SUB%20id%3D%22lingo-sub-3003869%22%20slang%3D%22en-US%22%3EPROBLEMS%20WITH%20COUNTIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003869%22%20slang%3D%22en-US%22%3E%3CP%3EIhave%20aworkbook%20with%203%20sheets%2C%20one%20a%20list%20of%20names%2Fadresses%20in%20our%20database%20andsent%20to%20a%20company%20to%20check%20the%20addreseses%20for%20validity(my%201st%20sheet)%20and%20sent%20to%20the%20USPS%20(my%202nd%20sheet.%20to%20print%20bar-coded%20address%20labels.(my%203rd%20sheet)%20for%20some%20reason%20a%20label%20is%20not%20produced%20for%20a%20few%20names%20in%20the%20list%20sent%20to%20the%20USPS.%20I%22m%20trying%20to%20determine%20why.Also%20when%20I%20try%20to%20modify%20my%20countif%20function%20in%20a%20different%20column%20I%20get%20a%20VALUE!%20error%20saying%20the%20work%20book%20is%20not%20open%2Cbut%2C%20of%20course%2C%20it%20is%20simply%20a%20sheet%20in%20th%20same%20workbook%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3003869%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3004414%22%20slang%3D%22en-US%22%3ERe%3A%20PROBLEMS%20WITH%20COUNTIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3004414%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220713%22%20target%3D%22_blank%22%3E%40mARSHALL2230%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecould%20you%20please%20upload%20your%20file%20and%20provide%20some%20information%20on%20your%20Excel%20version%3F%20This%20will%20make%20it%20much%20easier%20fur%20us%20to%20understand%20and%20to%20provide%20a%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Ihave aworkbook with 3 sheets, one a list of names/adresses in our database andsent to a company to check the addreseses for validity(my 1st sheet) and sent to the USPS (my 2nd sheet. to print bar-coded address labels.(my 3rd sheet) for some reason a label is not produced for a few names in the list sent to the USPS. I"m trying to determine why.Also when I try to modify my countif function in a different column I get a VALUE! error saying the work book is not open,but, of course, it is simply a sheet in th same workbook

1 Reply

Hi @mARSHALL2230 

 

could you please upload your file and provide some information on your Excel version? This will make it much easier fur us to understand and to provide a solution.