Nov 17 2020 12:49 AM
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 #
Nov 17 2020 01:06 AM
I don't know where is D25:D31, but totally there are 7 cells in the range (31-25+1), not 8