Formula to calculate against 2 columns to produce a figure

Hi all

I'm a little confused with getting a dashboard to work as I need to count multiple columns to get a figure

Basically, what I'm trying to do in the first dashboard tab column D4 is count the number of Red projects in column M against the Stage in column C for the word 'Discovery'.

So Discovery = 1 red RAG

I can then use that same formula and change it a bit to calculate Discovery number of ambers etc etc.

Hope that makes sense, as I haven't done counts against 2 different columns against a certain word.

Many thanks

Matt