Count colors and nonblank cells

Originally Posted by LostInAus

Hi Everyone
I have an existing worksheet that can count specific background colors in a range and then multiply the result by another cell. It does this using a VBA procedure, coutesy of Chip Pearsons page.
I now need it to do this only if the cell contains text (any text).

Any help will appreciated.

Thanks in advance.

this appears to be a second (or double) post
-- see you original post