SumIf will not work - why?

I've tried this formula multiple ways - why won't it work?

Doing Org(s) column is a dropdown from a form, but I created another column to try it hard coded data, and it won't work either.

Answers

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭

    Hi @REChez - If you're doing a limited range instead of the full column, you need to make sure they match. In the first area (the range for your IF clause), you're looking at rows 1-234. In the last area (the SUM range), you're doing rows 1-235. Have you tried making both either 234 or 234? Also, remove @row from your "Criterion" area. You just need [Doing Org(s)]129 (if you're saying the criteria is whatever is in that column in row 129). It would look like this.

    =SUMIF([Doing Org(s)]1:[Doing Org(s)]235, [Doing Org(s)]129, [2023 Total Spend]1:[2023 Total Spend]235) * 4

    Does that work?

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!