Basically, I want the word, "Pink" to appear if SUM(E55:E67)=3; the word,
"Yellow" to appear if SUM(D55:D67)=2; and the word "Blue" to appear
otherwise.

On the face of it, try this:
=IF(SUM(E55:E67)=3,"Pink",IF(SUM(D55:D67)=2,"Yel low","Blue"))

The IF evaluates from left to right. Since you are testing 2 different
ranges, the sequence of the test becomes important. If the 1st IF test is
TRUE, you'd get "Pink" irrespective of the result from the 2nd IF test (which
will never get evaluated).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---