Need help with a SUMIF formula to sum the number of credits with multiple AND and OR functions
This is a continuation of the question that was answered here: https://community.smartsheet.com/discussion/91230/need-help-calculating-number-of-credits-with-multiple-and-and-or-functions#latest
The answerer found the correct formula! Results are in the screenshot below.
I need help creating the correct formula syntax in a different sheet (that would reference the above sheet) that follows the following logic:
Sum the credits from the January column (see above) if Assigned To = Cathy's email address AND (Start Month = 1 AND Start Year = 2022) OR (End Month = 1 AND End Year = 2022)
The goal is to sum the credits from the sheet above by Month, Year and colleague name (the Assigned To column above is a Contact List field) so that we can populate the grid below (which exists in a separate sheet):
Help Article Resources
Check out the Formula Handbook template!