Thursday, June 20, 2013

yogi_Trim Out Strings For Spurious Space Characters For Correct result using COUNTIF

                                          Google Spreadsheet   Post  #1253
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 20, 2013
user Daniel Nice (http://productforums.google.com/forum/?zx=o5tj0hu108x2#!category-topic/docs/spreadsheets/yZoe_HwqOv0)
Need help counting values within array
Can someone please explain to me why the top countif works as expected and the bottom one does not?

https://docs.google.com/spreadsheet/ccc?key=0AjK4ZXNh_OmpdHJhdjN2SjhTOUhKSkN0UVBnNjJ1d0E&usp=sharing
Me, too!
----------------------------------------------------------------------------------------------------------------------------------------------------