SumIF formula not working

Hi All,

I am having a bit of trouble with a SUMIF formula not working. See below formula

Formula:

=IFERROR(IF(BR$2=0,0,IF(NOW()<BR$2,IF($B7=BR$3,BR7,IF(BR$2>=$B7,SUM(SUMIFS($J7:BR7,$J$3:BR$3,">="&$B7,$J$5:BR$5,"* - R"),SUM(SUMIFS($J176:CC176,$J$171:CC$171,">="&$B7,$J$173:CC$173,"* - R"))),SUM(SUMIFS($J7:BR7,$J$3:BR$3,"<"&$B7,$J$5:BR$5,"* - R")))),BV7)),"")

Breakdown of the formula:

Circular reference to make sure changes don't occur throughout the year - Works fine
SumIFS
1. to look at the date in B7 and add everything after that date (I've got the before in there as well but it's irrelevant, was using it on another spreadsheet)
2. Look for either the letter "*- R" or "*- S". in row 5 - The section I cannot get to work.
Picking up the "*- S" works but if I change the formula to the "R" it doesn't work and I have no idea why.

Has anybody got any clues to why?

Attached example workbook. Formula's in column D relate to the February column.

TIA