Hello!
I utilize numbers to track my school assignments, I'm wondering if there is a formula that can auto-calculate the percentage completed/remaining. Here is a snapshot of my assignment tracker to get a better picture of what I'm looking for.
MacBook Air 13″, macOS 14.6
Hi Cade_C,
Here is an approach that is more Numbers-like and less Excel-like.
I copied the text in your row 1 and pasted it into the table title. Then I removed your Row 1.
I converted the new Row 1 to a Header row (very useful in Numbers!)
I deleted your grey "Separator" rows and inserted Cell Borders instead.
Here we go. The table has one Header row for the column labels.
The table has four Footer rows (also very useful in Numbers!)
Now notice one Charm of Numbers:
Header Rows, Footer Rows and Header Columns isolate themselves from the formulas, so we can refer to a whole row or column instead of a range of cells. For example E instead of E2:E31
Formula in Footer Cell E32 is COUNTIF(E,"TRUE")÷COUNTA(E)
Formatted as Percentage.
Formula in Footer Cell E33 is COUNTIF(E,"FALSE")÷COUNTA(E)
Formatted as Percentage.
Footer Cells E34 and E35 were simply for me to check the calculations. Delete Rows 34 and 35 if you don't need them.
Regards,
Ian.
Hi Cade_C,
Here is an approach that is more Numbers-like and less Excel-like.
I copied the text in your row 1 and pasted it into the table title. Then I removed your Row 1.
I converted the new Row 1 to a Header row (very useful in Numbers!)
I deleted your grey "Separator" rows and inserted Cell Borders instead.
Here we go. The table has one Header row for the column labels.
The table has four Footer rows (also very useful in Numbers!)
Now notice one Charm of Numbers:
Header Rows, Footer Rows and Header Columns isolate themselves from the formulas, so we can refer to a whole row or column instead of a range of cells. For example E instead of E2:E31
Formula in Footer Cell E32 is COUNTIF(E,"TRUE")÷COUNTA(E)
Formatted as Percentage.
Formula in Footer Cell E33 is COUNTIF(E,"FALSE")÷COUNTA(E)
Formatted as Percentage.
Footer Cells E34 and E35 were simply for me to check the calculations. Delete Rows 34 and 35 if you don't need them.
Regards,
Ian.
This is great, thank you!
Finding percentage complete in numbers
