sum the number values in a drop down box

Ashley Ryder

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

Ashley Ryder

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

Mark Cronk

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

Ashley Ryder

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

Ashley Ryder

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