Excel Count function returns "0"

Question

I have a very simple spreadsheet with one column showing values between 1 and 5. I used count to show how many cells had a value in them. the answer is an incorrect 0. If I cut the column and paste it elsewhere, same result. 

What am I not getting? COUNTA also gives me a 0 response.

Digby

Answer 1

Try Copy and Value paste somewhere in another sheet, for testing, and try it.

Answer 2

Hi Digby,

As per your description, use =COUNTIF(A:A, "=<5") or using "*" gives the correct results for example in formula =COUNTIF (A:A, "*<5*")

Also, try formatting cell as numeric.

If you still get return zero value can you share a sample value range, worksheet structure and the formula you are using.

I appreciate your time and understanding.

Best Regards

Waqas Muhammad

Answer 3

Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

Answer 4

Hi Digby,

Feel free to post back if you need further assistance.

Best Regards,

Waqas Muhammad

Answer 5

Hi Digby,

You can post back anytime when you free or need further help.

In the meantime, I would like to make a summary on this issue to find the information easily. This will also help other community members to find solution much easier of they come across the same situation:

Issue Description :

In Excel 365 Count function always returns "0" value.

Environment :

Office 365 for business.

Suggestion :

1.  Try to use =COUNTIF (A:A, "=<5") or using "*" gives the correct results for example in formula =COUNTIF (A:A, "*<5*")

Copy and paste data somewhere in another sheet.

Best Regards

Waqas Muhammad