Not counting based on multiple factors
I'm building a formula that uses the contents in a cell to effect a percentage. Basically:
=(count all cells within a range with the word "PASS")
(divide this number by)
(All the cells within same range that are NOT blank )
The piece of the formula that looks at the row and avoids blank cells looks like this:
(COUNTIF(cellname1@row:cellname2@row, (NOT(ISBLANK), @cell)))
When I execute this formula, it still manages to count those blank cells. What am I missing?
Help Article Resources
Check out the Formula Handbook template!