I have tried editing some syntax to

=SUMIFS(INDIRECT("X6"),indirect("U6")&"!"&A4:A99," ="&P6,indirect("U6")&"!"&A4:A99,"<="&R6)

In the formula wizard it no longer reports any argument as invalid but when I run the function it tells me that there is an error in my formula.