SUMIFS Formula with Three Conditions
Hello all! I'm fairly new to SmartSheets and having troubles with a formula for our Sheet Summary.
Here is a screenshot with what I have started. I want to calculate the total number of units if the employee equals "MB" and HSW is one of the Applicable Categories from the drop-down.
I used the formula below but it returned a value of 0. What part of my formula is currently wrong?
To make matters worse, I want to eventually add a third condition if the Date Earned column is in the year of 2023.
=SUMIFS([Total CE Units]:[Total CE Units], Employee:Employee, "MB", [Applicable Categories]:[Applicable Categories], "HSW")
Help Article Resources
Check out the Formula Handbook template!