Sum cells in varying column length with if-then?
Not sure if this is possible. Column can vary from 2 to X cells
A couple of scenarios:
A column two cells with 12 and 14. Total is 26. In the resultant cell 16 is inserted. (any sum of 17 or greater the number 16 is inserted)
A column has a number of cells that total 14. Seeing that the number is less than 16 the actual number of 14 is inserted.
A formula that sums a group of cells in a column selected, sums that group. If =<16 is inserted in resultant cell. 1f sum =>17 then 16 is inserted in resultant cell.
Thanks in advance for any suggestions.
Best Answer
-
You can use an IF function to do this.
=IF(SUM([column name]:[column name])>=17,16,SUM([column name]:[column name]))
If the sum of the column is greater than or equal to 17 return 16, if not return the sum of the column.
Answers
-
You can use an IF function to do this.
=IF(SUM([column name]:[column name])>=17,16,SUM([column name]:[column name]))
If the sum of the column is greater than or equal to 17 return 16, if not return the sum of the column.
-
Thank you!!! Works great!
-
Great! Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!