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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!