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!

----------------------------------------------------------------------------------------------------------------------------------------------------