=SUMIFS('VISTA DUMP'!A:A,A1,'VISTA DUMP'!G:G,"OPEN",'VISTA DUMP'!J:J)
Hey guys cant get this formula right i am trying to make a sumifs formula to check if column A in sheet 1 appears in vista dump column A and contains "open" in vista column G it will add the corresponding numbers in vista...