Counting - Color of cell and words in the cell

So I know how to do each of these separately. For example, if I want to count cells that contain a shade of blue, I use the VBA function

=SUMPRODUCT(--(COLORINDEXOFRANGE(Sheet1!E:E,FALSE,1)=COLORINDEXOFONECELL(Sheet1!A1,FALSE,1)))

which counts any cells in row E that match the color in cell A1.

For certain words in a cell, I use the function

=COUNTIF(Sheet1!E:E,"=ABCD")

which counts any cell in row E that contains 'ABCD'.

But despite all my efforts, I cant figure out a way to combine both of these. I want to count all cells that are the shade of blue in A1, but also contain 'ABCD'. I've tried COUNTIFS and SUMPRODUCT and a few others but can't get it to work. Any help would be much appreciated

I'm getting an error when I try that...

I attached a sample workbook where I tried that... said that the function isnt valid when I copy/pasted it into this workbook.

Originally Posted by ChemistB

You cannot use VBA functions in a cell. I assumed that COLORINDEXOFRANGE and COLORINDEXOFONECELL were User Defined Functions (VBA based). Is this the case?

Correct. I'm using the functions from this site.

http://www.cpearson.com/excel/colors.aspx