•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
Our take
It appears you're encountering an issue with the =COUNTA() function returning 0, despite having non-blank cells in the specified range. Initially, the formula in E136 should have counted the dummy values entered above it, but it didn’t. After moving the formula to another column to avoid circular referencing, the problem persisted. However, once you identified and removed an unrelated circular reference in column D, the COUNTA function in column E began working correctly.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- For some reason my COUNTA function is returning one too many results (also how to quickly fill many cells with sequential numbers?)https://preview.redd.it/1hz8k8yc75kg1.png?width=689&format=png&auto=webp&s=560395ff19be6c9f7d617fd57702f49fbdbd9939 I have COUNTA to read from A2, to 502, since that goes up the the '500' that I need. However, for some reason, the function is returning 501. The first cell it's reading, a2, starts at 0 (labeled with the number zero), then up to cell 502, which is labeled 500. Also, for desktop/free use, is there a faster way to do sequential numbering. I had a tough time doing the =sequence function, and then I don't have access to some of the other fill tools, and since I'm just learning, I don't have the money for a subscription right now. submitted by /u/Kieotyee [link] [comments]
- Issue with sum count in mirrored spreadsheet?Hi, I've been trying to deal with a thing to count completion for two-mod combos in a game my friends and I play. It's supposed to be mirrored, and it's worked until I expanded the sheet by three rows and columns. I have the following formulas to count the cells that have text that isn't a formula =SUMPRODUCT( --ISTEXT(B2:CD82), --IFERROR(FORMULATEXT(B2:CD82)="", TRUE) ) and the following to count everything that doesn't have a formula =SUMPRODUCT( --(B2:CD82<>""), --IFERROR(FORMULATEXT(B2:CD82)="", TRUE) ) But it's not working, it's just saying both are 0. What am I doing wrong? Here's an image of the spreadsheet, sans the calculated part: https://imgur.com/a/SJ4qZEd submitted by /u/CharlieTheAnon [link] [comments]
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