SUMIFS cross sheets for months and years


I am trying to calculate total Amount in sheet#1 below by referring to sheet#2's [Date Sent to Client] and [Related Opportunity: Amount]:


So the Amount in sheet#1

SUMIFS({Sheet#2}[Related Opportunity: Amount], YEAR(Sheet#2[Date Sent to Client]=STC-year), MONTH(Sheet#2[Date Sent to Client]=STC-Month)

I have tried many times but still frustrated to make it work. Thanks


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!