Hi,
U can use

=SUMIFS(Value,Color,"<>"&"Green")


Thanks & Regards,
CMA Vishal Srivastava