Bring your Excel workbook into the modern ... Add three columns to your existing sheet — Tick, Percent, and Progress. Use the following formula under the Tick column. =COUNTIF(D6:AG6, TRUE ...