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

That makes perfect sense and now it works, thank you!

I would love to change the format but I don't think it's possible, I've got 150 different suppliers with 3 years worth of data. (It was quite a wide spreadsheet before but I am in the middle of overhauling and each year will have it's own table. that spreadsheet has links to an import tab to gather the spend each month and is then copied onto another document to figure out what the journal entries for Sage are.)

I've spent literally months over the past few years trying to update the spreadsheet for ease of use, but to the best of my knowledge this is the best way I can think of. (Although it is forever changing.)

If you have any other suggestions, I would be open to hearing them.