#CIRCULAR REFERENCE with =SUMIF Formula
For each month, I am trying to sum up data depending on the type of project it is. For example, "If the 'Project Type' is 'Strategic', this is the total hours for the month of February," "If the 'Project Type' is 'Operational', this is the total house for the month of February."
These the formulas I tried using:
=SUMIF([Project Type]:[Project Type], "Strategic", [Month 1]:[Month 1])
=SUMIF([Project Type]:[Project Type], "Operational", [Month 1]:[Month 1])
I kind of understand why I am getting the error codes, but I also don't understand because I have different criteria I want the formula to look at before providing the sum.
(I've blocked out the project names just to cover my bases)
I am new to Smartsheet, so please advise on how to fix these formulas or if I'm using the wrong formula altogether.
Help Article Resources
Check out the Formula Handbook template!