Formula to calculate against 2 columns to produce a figure

[MattExcelLearner]

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

[Glenn Kennedy]

D4:

=LET(A,'Portfolio Extract current'!$C$2:$C$60&" "&'Portfolio Extract current'!$M$2:$M$60,ROWS(FILTER(A,A=B4)))

similarly for the others.

[MattExcelLearner]

Awesome Glenn,

That worked perfect and for the others that's totally perfect

Many thanks

[Glenn Kennedy]

You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.