Forum Discussion
juank1015
Nov 17, 2020Copper Contributor
Countif
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 #
I don't know where is D25:D31, but totally there are 7 cells in the range (31-25+1), not 8