SOLVED

Trouble with a formula in EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-1426823%22%20slang%3D%22en-US%22%3ETrouble%20with%20a%20formula%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20search%20a%20sheet%20with%20three%20particular%20columns%20of%20interest%3A%26nbsp%3B%20and%20I%20want%20to%20count%20up%20the%20number%20of%20instances%20that%20match%20%E2%80%A6%20the%20last%20check%20is%20for%20a%20blank%20cell%2C%20and%20I%20can%20not%20see%20to%20get%20it%20to%20work.%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3Ewhat%20would%20be%20the%20correct%20way%20to%20get%20a%20valid%20answer%20%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIFS('CMDB%20Pull%205_28'!K%3AK%2CB2%2C'CMDB%20Pull%205_28'!D%3AD%2C%22Symantec%20Endpoint%20Protection%22%2C'CMDB%20Pull%205_28'!F%3AF%2C%22isblank%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1426823%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-1426843%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20a%20formula%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426843%22%20slang%3D%22en-US%22%3E%3CP%3Eby%20typing%20%22isblank%22%20it%20is%20checking%20if%20the%20cell%20contents%20say%20that%20text.%20Try%20using%20%22%22%20instead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW%20you%20do%20know%20that%20countifs%20treats%20those%20conditions%20with%20an%20AND%20logic%20and%20therefore%20all%20those%20conditions%20must%20be%20true%20and%20not%20OR.%26nbsp%3B%20I%20think%20that%20is%20what%20you%20want%20but%20wanted%20to%20mention%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426864%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20a%20formula%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426864%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStill%20gives%20me%20a%200%20answer%20%E2%80%A6%20and%20that%20is%20not%20correct%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426904%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20a%20formula%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426904%22%20slang%3D%22en-US%22%3Emaybe%20attach%20the%20sheet.%3CBR%20%2F%3Eto%20debug%20I%20would%20check%20each%20condition%20individually%20to%20make%20sure%20it%20is%20pointing%20to%20the%20correct%20range%20and%20values.%20Also%2C%20are%20cells%20in%20col%20F%20blank%20or%20have%20spaces%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426957%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20a%20formula%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426957%22%20slang%3D%22en-US%22%3EWorked%20perfectly%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am attempting to search a sheet with three particular columns of interest:  and I want to count up the number of instances that match … the last check is for a blank cell, and I can not see to get it to work.

what would be the correct way to get a valid answer ?

 

 

=COUNTIFS('CMDB Pull 5_28'!K:K,B2,'CMDB Pull 5_28'!D:D,"Symantec Endpoint Protection",'CMDB Pull 5_28'!F:F,"isblank")

 

 

4 Replies
Highlighted
Best Response confirmed by Cynthia Sullivan (New Contributor)
Solution

by typing "isblank" it is checking if the cell contents say that text. Try using "" instead.

 

BTW you do know that countifs treats those conditions with an AND logic and therefore all those conditions must be true and not OR.  I think that is what you want but wanted to mention it.

Highlighted

@mtarler 

 

Still gives me a 0 answer … and that is not correct

 

Highlighted
maybe attach the sheet.
to debug I would check each condition individually to make sure it is pointing to the correct range and values. Also, are cells in col F blank or have spaces?
Highlighted
Worked perfectly