Countif

[juank1015]

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 #

[#2]

@juank1015 

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