Help with COUNTIFS range, but return as percentage- not counting any row with "0"

I need help with the COUNTIFS function. Right now I have =COUNTIFS(D3:D59987,"<30",D3:D59987,">17"), but it's returning a "0", even though I know there are numbers within that range. I also want the resulting number returned as a percentage of the total number of rows, but exclude any row that is "0". For example the data is like:

First name, Last name, age
John, Doe, 16
John, Doe, 43
John, Doe, 30
John, Doe, 0
John, Doe, 44
John, Doe, 56
John, Doe, 57
John, Doe, 71

I don't have to capture/count anything related to the names, just the age. I want my results to show how many are within the below ranges:

Pax 1-17 = x%
Pax 18-29 = x%
Pax ...
Pax 70+ = x%

Total # of rows = 59986

If I need to, I can return just a regular number rather than a percentage and just create another results row to get the percentage. BTW, in my sheet, Column D is the age column.

If I need to, I can return just a regular number rather than a percentage and just create another results row to get the percentage.

Hi jjcgr and welcome to the forum.

I need help with the COUNTIFS function. Right now I have =COUNTIFS(D3:D59987,"<30",D3:D59987,">17"), but it's returning a "0", even though I know there are numbers within that range.

This sounds like the numbers are text "numbers". They may look like numbers but have no numeric value.

To test this in E3

=ISNUMBER(D3) and fill down. True means they are numbers and False ... well you get the picture.

If they are false using text to columns often fixes the problem.

If neither of these things point you in a helpful direction try uploading a sample Excel file (not a screen shot or pic. they are not helpful for trouble shooting)

If you are not familiar with how to do this


To attach a file to your post,

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”
• be sure to desensitize the data

The file name will appear at the bottom of your reply.