SUM by month

Options

Hi guys,


I'm trying to total income by month, and my formula is not working. Can someone please advise where I am going wrong?

=SUMIFS({Fee}, {Date Received}, MONTH(@cell) = 10, {Date Received}, YEAR(@cell) = 2020)

Where {Fee} is what I need to sum. I'm then trying to sum in November 2020 in the above example...


Feel like I'm going mad trying to work it out!


Any help appreciated.


Thanks,


Meg

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!