Inconsistent incorrect %
You will see below, I have a formula that, when copied into all of the column cells, the % calculation is incorrect inconsistently. Some are correct, eg, 33%, and others are not, eg, anything over 100%. The formula and cell formatting is the same for each cell in column "% Complete.
I do know I can separate two of the columns for the formula (remove one of the countifs, but another column will soon be added that will not be part of the formula :-)
Any help in correcting the percentages would be appreciated!
Help Article Resources
Check out the Formula Handbook template!