•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can you make COUNTA ignore cells or words?
I'm sorting people in buildings and using COUNTA to keep track of the amount of people, then that just goes to a SUM. I want to remove people temporarily, and not have them in the COUNTA. I don't want to remove all the names then type them all over again. Is COUNTA the best option for this? or is their a way to comment out word or cells temporarily?
Thanks
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#COUNTA
#SUM
#people
#cells
#temporarily
#ignore
#remove
#track
#sort
#names
#option
#words
#comment out
#building