Ravi Sir's Cards › Excel
To-Do List in Excel (card 1 of 2)
Revision card 1 for To-Do List in Excel: Number of tasks: =COUNTA(A6:A15) gives 10; Tasks done: =COUNTIF(E6:E15,TRUE) gives 3; Done %: =J7/J6 gives 30%. Includes an example data table.

Read card text
What this card says
1 for To-Do List in Excel: Number of tasks: =COUNTA(A6:A15) gives 10
Tasks done: =COUNTIF(E6:E15,TRUE) gives 3
Done %: =J7/J6 gives 30%. Includes an
Example
data table
Learn this in the lesson: To-Do List in Excel with Priority, Due Dates, a Done Checkbox and a Progress Bar