No ...cell contains either "Complete" or "1" not both. Why both? To get %
completion, use
=COUNTIF(B2:D2,"Complete")/3 formatted as %
HTH
"mheavers" wrote:
Hi guys, I have a spreadsheet that looks as follows
Packslip | Text | Photo | SEO | % Complete
440158 | 1 | 0 | 1 | 66%
440159 | 0 | 1 | 0 | 33%
The ones in this spreadsheet represent "complete" and the zeroes
represent "incomplete" -
The % complete field automatically calculates the total of the 3 stages
of completion and divides them by the number of stages (3) to
calculate a percentage. What I want to be able to do is write
"complete" in place of "1" and have it still asign a numerical value of
"1" in my formula. Is this possible? Thanks!
Mike