I would love to be able to concatenate any non-blank entries from a list.
Unfortunately, I can't seem to do that other than manually entering each cell
reference into a CONCATENATE() command. What I'd love to see, in order of
preference, is:

CONCATENATE(A1:A100) - Pretty obvious
CONCATENATEIF(Range,Criteria,Concat_Range) - Like SUMIF, but concatenates
DCONCATENATE(Database,Field,Criteria) - Like DSUM, but concatenates