Forum Discussion
Bjrnen
Apr 12, 2024Copper Contributor
Summing random marked cells
Hello! I am trying to create a sheet with various products I am selling. Alla I want to do is to mark the price cells using ctrl+mouse-click to mark them and the total sum to appear in the designate...
Bjrnen
Apr 12, 2024Copper Contributor
MAngosto Maybe I wasn't clear enough. I want it preset so I don't need to write any formula, only once...
I simply highlight or mark the cells and it directly shows up in the pre designated cell what the sum of it all is.
Or if I make "checkboxes' and it sums up those
SergeiBaklan
Apr 12, 2024Diamond Contributor
Yes, you may do that with check boxes. It's easier now on Beta version, otherwise perhaps more convenient is to use drop-down lists from data validation, like
- BjrnenApr 12, 2024Copper ContributorThank you! That might work!
- SergeiBaklanApr 12, 2024Diamond Contributor
Bjrnen , you are welcome