tag:blogger.com,1999:blog-9092970177046142644.post3981627829229529285..comments2024-02-15T23:26:05.800-08:00Comments on Excel for Educators: The Zero EffectThe Science Goddesshttp://www.blogger.com/profile/02846516022505481326noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-9092970177046142644.post-10185957199529456732012-02-08T13:19:39.438-08:002012-02-08T13:19:39.438-08:00I don't know why it's freaking about about...I don't know why it's freaking about about the ' in your last name. We must have encountered a time warp back to the ASCII days.The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-27253730814932302992012-02-08T12:07:12.773-08:002012-02-08T12:07:12.773-08:00BTW, What's with all the goobers in my name? B...BTW, What's with all the goobers in my name? Blogger having an issue?Hugh O'Donnellhttps://www.blogger.com/profile/02508898599669167706noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-51770423724598120702012-02-08T12:06:14.109-08:002012-02-08T12:06:14.109-08:00"A letdown, I'm sure; but ASCD did give a..."A letdown, I'm sure; but ASCD did give a big shout out to Excel for Educators in its most recent Express issue."<br /><br />Outstanding! :)Hugh O'Donnellhttps://www.blogger.com/profile/02508898599669167706noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-16052897467999533902012-02-07T05:53:28.828-08:002012-02-07T05:53:28.828-08:00A letdown, I'm sure; but ASCD did give a big s...A letdown, I'm sure; but ASCD did give a <a href="http://www.ascd.org/ascd-express/vol7/709-blogwatch.aspx" rel="nofollow">big shout out to Excel for Educators</a> in its most recent Express issue.The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-30214529477685372632012-02-06T23:55:49.633-08:002012-02-06T23:55:49.633-08:00When I saw the latest issue of Educational Leaders...When I saw the latest issue of Educational Leadership, "For Each to Excel," I thought somehow you'd commandeered editorship. What a letdown to find out it was all about personalizing the educational experience! :)Hugh O'Donnellhttps://www.blogger.com/profile/02508898599669167706noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-60192445841675511092012-02-06T16:10:51.895-08:002012-02-06T16:10:51.895-08:00Huzzah! I used your formula as a starting point an...Huzzah! I used your formula as a starting point and was able to come up with one that would work in the spreadsheet. I used =IF(COUNTIF(P5:P14,"1 = Below Basic"),COUNTIF(P5:P14,"1 = Below Basic"),"")<br /><br />Thanks for putting me on the right path!The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-33263224071105200282012-02-06T05:47:14.332-08:002012-02-06T05:47:14.332-08:00Hmmm...for some reason, that formula isn't wor...Hmmm...for some reason, that formula isn't working for me. It does keep the zero from showing up when there is nothing to total, but when there is something to total, the box is still blank.The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-65690087067368812602012-02-06T00:03:45.910-08:002012-02-06T00:03:45.910-08:00A hacky fix is to do something like
=IF(COUNTIF(P...A hacky fix is to do something like<br /><br />=IF(COUNTIF(P5:P14,"1 = Below Basic")=0,"",COUNTIF(P5:P14,"1 = Below Basic"))<br /><br />I don't like having to repeat myself in the formula but it's certainly the easiest way to achieve what you're looking for.Jamie Bullhttps://www.blogger.com/profile/18320993123584137767noreply@blogger.com