Tag Archives: #N/A

Conditional Sum On #N/A Text Values

Today’s post is inspired by a question which came up over at the MrExcel.com forums. Here’s my spreadsheet: It’s pretty simple. In cells A1:A2 I have the formula =”#N/A” and in cells A3:A4 I have the formula =NA(). Whilst the outputs … Continue reading


Posted in Microsoft Excel | Tagged , , | 1 Comment

Why Does VLOOKUP Return An #N/A Error?

VLOOKUP week enters its second day, meaning that it’s time to have a look at how to problem-shoot #N/A errors. On the online forums I frequently see frustrated users asking why their VLOOKUP formula returns an #N/A error, so I hope that some of the … Continue reading

Posted in Microsoft Excel | Tagged , , | 128 Comments