I've drawn a blank.
Column A = Dates (DD/MM/YYYY)
Column M = RAG Status ("R" or "A" or "G")
I need to count up all of the R's in January, all of the A's in January, and all of the G's in January.
And so on for the other months.
I've got
Which returns a count of all of the 'January' 's.
I've also got
Which returns all of the 'G' 's - but for the entire table.
I kinda need a combo of the two?
I was playing with
But that isn't quite hitting it... Any advice is appreciated!!
Column A = Dates (DD/MM/YYYY)
Column M = RAG Status ("R" or "A" or "G")
I need to count up all of the R's in January, all of the A's in January, and all of the G's in January.
And so on for the other months.
I've got
Excel Formula:
=SUMPRODUCT( --ISNUMBER(Table1[Monthly schedule - Planned Date]), --(MONTH(Table1[Monthly schedule - Planned Date]) = 1))
I've also got
Excel Formula:
=COUNTIF(Table1[RAG STATUS],"G")
I kinda need a combo of the two?
I was playing with
Excel Formula:
=COUNTIFS(Table1[Monthly schedule - Planned Date], SUMPRODUCT( --ISNUMBER(Table1[Monthly schedule - Planned Date]), --(MONTH(Table1[Monthly schedule - Planned Date]) = 1)),Table1[RAG STATUS],"G")
But that isn't quite hitting it... Any advice is appreciated!!