tag:blogger.com,1999:blog-264226589944705290.post1761279005198572692..comments2023-11-05T03:45:25.001-08:00Comments on God Plays Dice: A hack I'm disturbingly proud of, and its connection to some real mathMichael Lugohttp://www.blogger.com/profile/15671307315028242949noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-264226589944705290.post-47615227133001025692010-01-01T11:59:14.459-08:002010-01-01T11:59:14.459-08:00I usually use the data pilot for this kind of anal...I usually use the data pilot for this kind of analysis. By default it presents sums, but it's easy to change to counts instead.Unknownhttps://www.blogger.com/profile/17749680248853916269noreply@blogger.comtag:blogger.com,1999:blog-264226589944705290.post-23188305836543742622010-01-01T11:34:55.670-08:002010-01-01T11:34:55.670-08:00Nice hack, of course, but it sounded silly to me t...Nice hack, of course, but it sounded silly to me that OpenOffice didn't have a function to count values satisfying some condition (like being equal to some specific number, for example).<br /><br />So, as I would have done, had I needed that function, I used a popular search engine and found the countif function your other commenters mentioned.<br /><br />I'm curious: did you do it your way instead of googling the name of the appropriate function because it was more fun? I often do things like that...Omarhttps://www.blogger.com/profile/06206510761450721045noreply@blogger.comtag:blogger.com,1999:blog-264226589944705290.post-5696354610678039362009-12-31T22:08:09.644-08:002009-12-31T22:08:09.644-08:00In EXCEL, @COUNTIF(range,criteria)
Counta for non...In EXCEL, @COUNTIF(range,criteria)<br /><br />Counta for non-empty.<br /><br />Or, if you have a column to waste, set up a column that is 100^n (where n is the corresponding 0, 1, or 2. The sum of the new column will be a nifty 6 digit number, encoding all the info you want.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-264226589944705290.post-12463564065385883002009-12-31T14:34:24.859-08:002009-12-31T14:34:24.859-08:00Good luck on your job search, btw. The process do...Good luck on your job search, btw. The process does seem to be good at producing unlimited amounts of anxiety.Mikehttps://www.blogger.com/profile/06326511096301074970noreply@blogger.comtag:blogger.com,1999:blog-264226589944705290.post-59885631292535053932009-12-31T13:54:41.378-08:002009-12-31T13:54:41.378-08:00I believe that the COUNTIF function is implemented...I believe that the COUNTIF function is implemented which should let you count how many items have 0, > 0, 1, > 1, or 2.Unknownhttps://www.blogger.com/profile/15397038518267760057noreply@blogger.comtag:blogger.com,1999:blog-264226589944705290.post-27140856830006286852009-12-31T13:52:55.072-08:002009-12-31T13:52:55.072-08:00Have you tried the Frequency command in OpenOffice...Have you tried the Frequency command in OpenOffice? I think it will perform the counting operation you are looking for.christopherdruphttps://www.blogger.com/profile/13153945213923468590noreply@blogger.com