One last thing.I can manage this one on my own but it's taking so long to do it the way I'm going at it.Basically, I've overpopulated most of my drop down list items, some by over 100 and I'd like to restrict the results that can be chosen by the user.Right now, I'm deleting each value in the List Item field in the cell tab one by one but I have a lot more to go and this could take a few hours at this rate. Is there no way for me to just highlight a large chunk and remove it that way or do I hav...

Thank you so much, it's weird becase I thought I had that covered but obviously something was missing.Truely appreciated.

Still not having any luck. I appreciate you simplifying it for me.If I name the cells down the column A1, B1, C1, D1....etc my script should look like: (my drop downs start on row 4)this.rawValue = (Row4.CellA1.rawValue * 1) + (Row4.CellB1.rawValue * 1) + (Row4.CellC1.rawValue * 1) + (Row4.CellD1.rawValue * 1);......etcOr do I just have (Row4.A1.rawValue *1)......etc.Thanks for the guidance.

Thanks for your reply,I was trying with FormCalc, when I tried javascript I get a zero in the total field but when I select number with the drop box (in preview) I don't get a total, just stays at zero.Getting closer though...Each drop down was named and given values 1 through 10, defaulot binding is set to normal (not sure if that makes a difference for my issue).Seems like I'm overlooking something simple.Thanks again.