sumifs formula

[cwhiteheadjr84]

=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 column j.

 

[cwhiteheadjr84]

sorry for the massive file went to post an image of what i was doing but it went crazy.

 

[Fluff]

With SUMIFS you need to put the column to sum first, followed by the criteria ranges.

Also (as you have noticed) you cannot upload images to the site.