Think the numbers you are trying to sum are text numbers

Instead of, say: =SUM(I1:I10)

Try, array-entered, ie press CTRL+SHIFT+ENTER
instead of just pressing ENTER:
=SUM(I1:I10+0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Will Emms" wrote:
Hi there,
I'd like to set up a spreadsheet with numerical drop down menus, the
selected values of which can then be taken and added together using the sum
function. I've tried adding in a drop down using the forms tool bar but sum
function won't seem to add the values.
Can anybody help?
Thanks
Will