Forum Discussion
Solved
Sum Total from Merged Boxes with Drop Down
I just don't have the knowledge to do this. I have 7 boxes where you can choose 1, 3 or 5 from a drop down menu in each box. Each box is also 3 merged cells and there are empty cells between each. (a...
That doesn't work, unfortunately. The choice is to pick 1, 3, or 5 from each box. With the boxes being empty I'm getting a sum of 75 instead of 0. It's summing up all of the choices, not the one picked. I have Microsoft 365. The cells between will not contain numbers.
Thank you
Thank you
- LOL, that was an error on my part. I transferred the formula and didn't account for it being a different column. Thanks very much for solving my problem. 🙂