SUMIF or SUMIFS (multiple columns and YEAR and MONTH criteria)

mariahneu ✭✭✭✭
edited 06/17/22 in Formulas and Functions

Formula Logic (for the formula that would be a column formula for the Jan column - needs to be a single formula):

SUM ([Received Count] if [Date Recd]'s YEAR = 2022 AND MONTH = 1) and also SUM ([Completed Count] if [DateCompleted]'s YEAR = 2022 AND MONTH = 1)

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!