Forum Discussion

Kerry Trafton's avatar
Kerry Trafton
Copper Contributor
May 25, 2017

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...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 25, 2017

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)
  • Kerry Trafton's avatar
    Kerry Trafton
    Copper Contributor
    May 25, 2017

    Thank you!  I am not sure how I missed that.