Forum Discussion
Please help with formula
Hi everyone, I have a project plan spreadsheet that is color coded (Green, Yellow and Red) depending on the status of the task. I wrote a formula to auto calculate the overall project status bas...
Hi Kerry,
In your formula
=IF((COUNTIF(J10:J33,"R")/COUNTA(J10:J33))>10%,"R",
IF((COUNTIF(J10:J33,"Y")/COUNTA(J10:J33:A))>30%,"Y","G")
)
change
COUNTA(J10:J33:A) on COUNTA(J10:J33)
Thank you! I am not sure how I missed that.