•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to do =SUM with *
I need to be able to add from B6 to G6, however sometimes we use * to depict important events (for example 1*), this prevents a regular sum formula from working properly, it will add everything except the number with the *. is there a way to get this to work. bonus points if it can be worked into an array and the formula can be placed into cell h5 and have it work from h6 down (less chances for my coworkers to delete the formula.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives
#SUM
#formula
#array
#B6
#G6
#important events
#1*
#h5
#h6
#coworkers
#delete formula