I have two questions...

1. Is it possible to have a COUNTIF (or something similar) only count cells
containing words with RED text?

2. Is it possible to make a CONCATENATE function echo multiple lines?

Instead of the result being:
The Total Is = 456

Have the result be:
The
Total
Is
456

Thanx.