•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