sum the number values in a drop down box
Hi all
Hoping for some help with this one please
column name is Units and it is a single select drop down box with the choices of selecting a number between 1 and 10 i would like to know if i can create a formula to sum the total i.e if one cell has 1 in it and the 1 below has 2 it sums it to 3 - seems easy if its just a numer in a cell but not if its a drop down box! any help is appreciated.
Thanks
Ashley
Best Answer
-
Hi Mark
update to previous comment left - I changed column type to single select for Drop Down option and it worked which will do for me! - thank you for your contribution
Ashley
Answers
-
Hi @Ashley Ryder ,
Try:
=SUMIF([drop down]:[drop down], ISNUMBER(@cell))
Replace [drop down]:[drop down] with the name of the column you want summed.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi Mark thank you for responding have tried it and it returns a value of 0 which is unusual as normally get the dreaded unparsable error so part of the formula is calculating something ?!?
Regards
Ashley
-
Hi Mark
update to previous comment left - I changed column type to single select for Drop Down option and it worked which will do for me! - thank you for your contribution
Ashley
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!