Tag Archives: IFNA

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