I have some large spreadsheets with rows of expected results for a specific
data element under various conditions. People entered whether or not the
expected results were received by changing the fill on the cell to green,
yellow or red.

I need to count the different results into Pass, Doc, and Fail. Help!!

Here is the situation:

X-Axis = Element Name
Y-Axis = Condition.
Cells contain either Y; N; or n/a

Row 1 has 5 cells = Red; 150 cells = Green; 30 cells = Yellow.
Row 2 has 15 cells = Red; 120 cells = Green; 50 cells = Yellow.
How don't care about the Cell values, but do care about the results (color).