Why would the result for TotalR = 0 (when it should return 226,550.00)
whereas TotalO returns the correct amount.

TotalR = Sheets("Imported Requisition Data").Evaluate("SUMPRODUCT(--(L9:L" &
myRowsR + 8 & "=" & OrderR & "),(G9:G" & myRowsR + 8 & "))")

TotalO = Sheets("JDE Data").Evaluate("SUMPRODUCT(--(B6:B" & myRowsO + 10

I've also noticed that results for other variables related to the ("Imported
Requisition Data") sheet appear as "725", whereas the results from ("JDE
Data") sheet comes through as 725.

I think this is part of the problem, but I've checked that the data in both
sheets is formatted the same way, and now I don't know what else to try.