Sum cells in varying column length with ifthen?
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
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!