SUMIFS issues

I've had a go at transposing this into a bigger version of the same thing, but it's bringing back the VALUE answer

in my latest effort, instead of just saying D or N, it has Green Amber and red (setup in the same fashion), like in this attached example - could you explain where i'm going wrong please?

***PLEASE IGNORE THE ABOVE, I'M AN IDIOT AND COPIED IT ACROSS INCORRECTLY***