Countif

%3CLINGO-SUB%20id%3D%22lingo-sub-1893864%22%20slang%3D%22en-US%22%3ECountif%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1893864%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20working%20on%20an%20existing%20excel%20document%20that%20has%20the%20following%20formula%26nbsp%3B%3DCOUNTIF(D25%3AD31%2C%22*%22)-COUNTIF(D25%3AD31%2C%22N%22).%20there%20are%202%20issues%20that%20i%20can%20not%20figure%20out.%20first%20the%20answer%20is%205%20of%208%20when%20it%20should%20be%205%20of%207.%20second%20idk%20how%20the%20person%20before%20me%20was%20able%20to%20get%20the%20%23%20of%20%23%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234039iB9E7112B2B4DFF70%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1893864%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1893980%22%20slang%3D%22en-US%22%3ERe%3A%20Countif%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1893980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F871417%22%20target%3D%22_blank%22%3E%40juank1015%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20know%20where%20is%26nbsp%3B%3CSPAN%3ED25%3AD31%2C%20but%20totally%20there%20are%207%20cells%20in%20the%20range%20(31-25%2B1)%2C%20not%208%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good morning,

 

I have been working on an existing excel document that has the following formula =COUNTIF(D25:D31,"*")-COUNTIF(D25:D31,"N"). there are 2 issues that i can not figure out. first the answer is 5 of 8 when it should be 5 of 7. second idk how the person before me was able to get the # of #Capture.PNG

1 Reply

@juank1015 

I don't know where is D25:D31, but totally there are 7 cells in the range (31-25+1), not 8