https://www.explainxkcd.com/wiki/api.php?action=feedcontributions&user=162.158.167.198&feedformat=atomexplain xkcd - User contributions [en]2024-03-28T17:46:42ZUser contributionsMediaWiki 1.30.0https://www.explainxkcd.com/wiki/index.php?title=Talk:1906:_Making_Progress&diff=147047Talk:1906: Making Progress2017-10-25T05:54:51Z<p>162.158.167.198: </p>
<hr />
<div><!--Please sign your posts with ~~~~ and don't delete this text. New comments should be added at the bottom.--><br />
What about "countless" and "COUNT()" in the title text? I think that's a pun... [[Jacob|User:Nobody]] at 1 January 1970 12:00 AM UTC<br />
:Not really, rather that is the purpose of "COUNT()" function, when you are not sure how numerous something is. --[[User:Trimutius|Trimutius]] ([[User talk:Trimutius|talk]]) 22:11, 23 October 2017 (UTC)<br />
The pun is that "countless" means they can't be counted, and the error message from the Count() function implies that the problems couldn't be counted. <br />
[[Special:Contributions/108.162.215.106|108.162.215.106]] 22:33, 23 October 2017 (UTC)<br />
:I agree that both the countless, the use of count and the fact that it failed is important, and this is currently not explained in the title text explanation. Hope someone with more familiarity with spreadsheets will try to make a good explanation of this --[[User:Kynde|Kynde]] ([[User talk:Kynde|talk]]) 11:51, 24 October 2017 (UTC)<br />
The COUNT() function only works on rows or columns of values rather than text. So if the problems are listed in a spreadsheet, likely as text, the COUNTA() function would really be the correct one...<br />
:Also, COUNT() won't provide an error in Excel, simply a 0 result (though a warning box is shown). Google Sheets produces the content of the title text. [[Special:Contributions/172.68.253.41|172.68.253.41]] 02:41, 25 October 2017 (UTC)<br />
:In Excel you can include the formula in the count by checking 'Enable iterative calculation' under options-formulas [[Special:Contributions/162.158.167.198|162.158.167.198]] 05:54, 25 October 2017 (UTC)</div>162.158.167.198