•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Help counting number of columns containing values greater than zero
Hello!
I have a table where I'm trying to count the number of columns containing values greater than zero, but only counting once per column and I'm struggling with the formula.
The cells D12:O12 could potentially contain any value from zero or above. If only D12 contained a value this would count as 1, if D12 and E12 contained values this would count as 2, and if D12, D13 and E12 contained values this would also count as 2 as I'm only interested if the column contains data or not.
Any help anyone can provide would be greatly appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#Excel alternatives for data analysis
#rows.com
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#columns
#values
#count
#counting
#greater than zero
#formula
#zero
#once per column
#data