Exclude strikethrough cells in a COUNT in Numbers

How do I exclude strikethrough cells in a COUNT in Numbers?

Posted on Feb 21, 2023 2:04 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 21, 2023 6:13 AM

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

1 reply
Question marked as Top-ranking reply

Feb 21, 2023 6:13 AM in response to Apple Seed UG

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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Exclude strikethrough cells in a COUNT in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.