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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!