Sum values on another sheet based on two columns

scott landon
scott landon ✭✭
edited 11/02/22 in Formulas and Functions

Hello, I am attempting to execute the following formula: =SUMIFS({Transfer Amount}, {Transfer Type}, "Recognized", {Month Invoiced}, >=DATE(2022, 1, 1), {Month Invoiced}, <DATE(2022, 2, 1)) where I want to sum values in a column based on a 2nd column's criteria and a 3rd date column range. The formula worked in test sheet but failed on my actual sheet. 


Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭

    Hi @scott landon,

    I can't help but notice there are no outbound arrows on your Transfer Type column cells. Check your cross-sheet references on your destination sheet, and make sure you have one for {Transfer Type}. I believe once that is set, your formula should run properly.

    Hope that helps!

    BRgds,

    -Ray

  • Thank you Ray, my cross reference was correct but apparently it was a synch issue because I came back later with no changes and it was working. Now the arrows appear. Good catch.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!