Exclude strikethrough cells in a COUNT in Numbers
How do I exclude strikethrough cells in a COUNT in Numbers?
How do I exclude strikethrough cells in a COUNT in Numbers?
You can't include or exclude based on whether you have specified the font to be strikethrough or not.
But you can count based on the value of checkboxes (or other conditions outside the font format)
For example, adapting the 'Checklist Total' template at File > New in your menu:
I changed the data format in the cell in column B of the Footer Row to Automatic, typed = to call up the formula editor and entered the formula:
COUNTIF(A,FALSE)
You can apply similar principles to your document, using checkboxes instead of font strikethrough to identify items you don't want (or do want) to count.
SG
You can't include or exclude based on whether you have specified the font to be strikethrough or not.
But you can count based on the value of checkboxes (or other conditions outside the font format)
For example, adapting the 'Checklist Total' template at File > New in your menu:
I changed the data format in the cell in column B of the Footer Row to Automatic, typed = to call up the formula editor and entered the formula:
COUNTIF(A,FALSE)
You can apply similar principles to your document, using checkboxes instead of font strikethrough to identify items you don't want (or do want) to count.
SG
Exclude strikethrough cells in a COUNT in Numbers