I have entered the following nested function, but it says the formula
contains an error.

=IF(SUM(E55:E67)=3, "Red"), (SUM(D55:D67)=2, "Amber"), "Green"

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.

Anyone know how I can do this? Any help would be much appreciated.