•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Checkbox adding true/false value to columns for SUM
Hi,
Trying to add true value to these columns of data so that if they are true they will be summed in the final column. So unchecked box will be false and not summed to final sum on last column.
Example, if the first column here is checked 291cell:0.7cell will be true. Then final column will see it true and sum the other columns that are true too.
I hope I explained that well enough, thanks all!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#natural language processing for spreadsheets
#true
#false
#sum
#checkbox
#true value
#columns
#final column
#summed
#data
#value
#unchecked