SUMIFS Cross Sheet Issue

ryan.diamond55371
ryan.diamond55371 โœญโœญโœญโœญ
edited 12/09/19 in Formulas and Functions

Hello Everyone!

I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What Iย am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1:

Criteria from Sheet-1

  • Job ID
    • 216116
  • Cost Code ID
    • 7
    • 15
    • 16

Sum Range: Act. Expenses

Basically I want to add all the specified cost codes from a specific job ID and when I create the formula the return value on Sheet-2 for the Row: Engineering, Column: Act. Expenses is 0.

Let me know what you all think, I was wondering if blank cells would affect the process but I am not sure.

-RD

Sheet-1.JPG

Sheet-2.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!