To SUMIF or SUMIFS - Neither are working

I am a newbie and I'm stumped. I am trying to calculate the remaining budget for projects that have a ProjPortStat(us) as "active" in a field on the Sheet Summary (I can successfully calculate a single column where the status is "active").

I've tried 100's of permutations of SUMIF and SUMIFS and each time is either UNPARCEABLE or INVALID OPERATION. The below formula is just the latest in my Summary Sheet Field.

=SUMIFS(ProjPortStat:ProjPortStat, "Active", (Budget:Budget - Spend:Spend))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!