INDEX, MODE, MATCH returning #NA

Don't know how much information I need to provide but here is what I am trying to accomplish. I have a column of "Parts" I want to take the most frequent recurring part and have it populate into a "Most popular parts"

the formula I am using is {=INDEX(D5:D90,MODE(IF(D5:D90<>"",MATCH(D5:D90,D5:D90,0))))}

The formula working fine and giving the intended result. this formula will be running across 12 pages (JANUARY-DECEMBER) and will have a Year To Date Summary page.

What is happening is the #NA that is being generated in the "Most popular parts" on the 11 pages of the non current month is returning a #NA on my summary page.

How could I change this formula so the #NA is not counted, doesn't return as a #NA, and doesn't contributed.

Hello Sl0vvP0ke and Welcome to Excel Forum.
I believe that it would be easier to help if you would upload a sample workbook (probably only need three of the monthly sheets and the summary) that shows the results you are currently getting (#NA's) as well as the results that you want (manually input).
To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window. Remember to desensitize the data if necessary.
Let us know if you have any questions.

Where is Shivya's post? What was the correction suggested, please?