1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Count cells that are occupied in the columns

In the image below, I want to create a formula that counts the cells that are occupied with the panel name (G43, L444, etc) and skip the cells where there are no contents.

https://preview.redd.it/6l8a52c2hy1h1.png?width=867&format=png&auto=webp&s=f9fdbb3bcd7719cbd52081949cf61c8f7324a93a

submitted by /u/Unusual-Librarian413
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#cells
#occupied
#count
#formula
#panel name
#contents
#columns
#image
#G43
#L444
#content
#excel
#skip