Sum values on another sheet based on two columns

scott landon

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. 

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

scott landon

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.