How to fix #NAME error in your Excel formulas

This video covers the top 4 causes of the #NAME error in Excel and how to fix them. By the end of this video you will have a fix for your #NAME formula error. The top 4 causes of the #NAME error in Excel are:

1. Misspelled formula
2. Misspelled cell range
3. Text without quotes
4. Misspelled name range

Misspelled formula - Make sure that you have spelled the formula correctly. For example, you might have misspelled VLOOKUP, SUM, or SUMIF. Correct the misspelling then you will fix the #NAME error.

Misspelled cell range - Maybe you spelled the formula correctly but misspelled the range within the formula. You might be missing the colon within the cell range or are using the wrong combination of letters and numbers to select the range.

Text without quotes - VLOOKUP, SUMIF, other formulas require string values to be entered in quotes. If your formula is missing quotes it will return a #NAME error. Add quotes to the string to fix the error.

Misspelled name range - Last but not least you might have misspelled your named range. Misspelling a named range will generate the #NAME error.

Please give this video a thumbs up

[ePCAYT]

Being someone who creates content on YouTube, it always amazes me how many people can learn from videos and yet not be "bothered" to click the Like button. Less than 1% of the Views were helped by this video. I doubt it!
Nice work!! Thank you!

[benfithian]

I saw your tab trick on one of your previous videos and still use it - has saved me mucho time and avoids #NAME errors

[nicknicolay]

Very helpful. I spend a lot of time trying to find my errors. Thanks.

[SNDVeteran]

THANK YOU SO MUCH IT WAS BECAUSE THE DATA VALUE IS A NAME AND IT FINALLY FOUND IT AFTER QUOTATIONS TRICK

[a-nq]

Your video helped me today. Thank you! :)

[carlynicolay]

Super helpful! Thanks for creating such quality content.

[tompetrac]

Awesome video brother! But, I have a problem typing number inside the formula... IT WON'T ACCEPT =FIND(''k'', A4, 1) IT WON'T ACCEPT 1 AS A NUMBER. What do I do? Please help!

[SpyderKhan]

My #Name? error only happens on my spreadsheet when i use it on my computer..when i use it on other computers it works just fine...why does that happen? Could it be the setting on the Excel program that i use? I am not an expert on Excel and my spreadsheet was done by someone else who himself does not know why that happens?😅 If someone knows why this happens, can you pls advise me? Tq

[AimanSyahir-ov]

So the result will be number? mine isn't number. So how do I remove =NAME? thing?

[fragrenceful]

sir i have put date in a2 colomn a and colomn b 2, amout and column c late payment, in c2 =ifs(TODAY()-A2<30, "under 30 days", TODAY()-A2<60, "under 60 days", TODAY()-A2<90, "under 90 days", TODAY()-A2<365, "under 365 days") even though showing name error? can you please explain where is the mistake in formula .i have put formula in column c2 only where is the mistake? can you please explain asap