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...
Thanks. Here is the link: https://www.dropbox.com/s/y7pa3w7efxcsxfi/Sum%20Test.xlsx?dl=0
If the cells in between are empty:
=SUM(A5:A43)
If the cells in between could contain numbers:
=SUM(IF(MOD(ROW(A5:A43),6)=5,A5:A43))
If you don't have Microsoft 365 or Office 2021, confirm the latter formula with Ctrl+Shift+Enter.
- 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- 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. 🙂