I've been asked to update the following to remove the array but I have no clue, any help is appreciated. this is just an example of one cell

{=(-(Q34/Q$31)*R$31)-SUM(IF(FileA!$B$48:$B$606=FileB!$B34,FileA!R$48:R$606))}

Thank you