Building a comma delimited string from Cell Range

Ok, after messing with this a few hours I find this function to be very quirky. I've setup an example worksheet and I can't seem to get it to work. Here is my example.