•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
=COUNTA() is returning 0 even when some cells in the range aren't blank
See image for reference. In E136 I've got the COUNTA formula. In the cells immediately above it I've entered some dummy values by hand. The COUNTA formula should at the very least return 4 based on this setup, but it's 0. I've tried repairing the file but that didn't do anything. Claude didn't produce anything helpful. Does anyone know why this is happening?
EDIT: Moved the formula to another column to avoid circular referencing. Still showing 0.
EDIT 2: There was an unrelated circular reference in a cell in column D that was apparently affecting column E. Once I removed the circular reference in column D, column E fixed itself.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives