•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formulas when column groups are hidden?
Not sure if this is possible but I'd like Column F cells to be a total of C, D, and E ONLY when the grouped columns are visible, when hidden I'd like to be able to punch in a value into column F and have it ignore or zero out any values in C, D, E
Is that possible?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#conditional formulas
#column groups
#Column F
#grouped columns
#C D E
#total
#value input
#ignore values
#zero out
#visible
#hidden
#formula logic
#user input
#functions
#Excel
#data manipulation