Sumifs not working between cross sheets

SimonSuperior

I am trying to add up a value if 2 criteria are met. I want to add the value of "Change Order Amount" if "Owner Approval" is "Yes" and it is "Cost Code" "1-Overhead"

HELP

Paul Newcome

It looks like you missed a comma between the first and second ranges.

SimonSuperior

My mistake on the sample. I am getting #invalid REF. once i corrected the comma. I have tried many different ways and still the same thing

Paul Newcome

It sounds like maybe you aren't setting up your cross sheet references properly.

Start typing the formula:

=SUMIFS(

Then click on the blue link in the formula helper box that says "Reference another sheet". A new pop-up window should appear. Select the sheet from the left panel and then select the range you want to reference. To reference an entire column, click on the column header. You can also rename the reference if you want.

Clicking on the blue button in the bottom right corner should close the pop-up window and you should now see...

=SUMIFS({Range Name}

From there, enter your comma and finish out the formula creating cross sheet references as outlined above where necessary.