SumIf will not work - why?

REChez

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.

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?