Alright, I have another problem. THis is the formula I'm using;

=IF(OR('Location 1'!J2:J2500="Reversed",'Location
1'!F2:F2500="TIL"),"Check",SUM('Location 1'!G:G))

What I want it to do is this; If Anywhere in J2:J2500 it says "Reversed" or
Anywhere in F2:F2500 it says
"TIL" then I want "Check" Displayed.

If not, I want to sum the G column from that same sheet.

This is on another sheet, that's why I have the Sheet name listed.
I tried it with "Til" listed in the F column and it's still giving me the
sum of the G column instead of "Check".

Any ideas would be greatly appreciated.