Monthly Archives: December 2014

2014 In Review

Here’s the usual RAD Excel annual summary report which WordPress.com provides each year. We had 180,000 views in 2014, which is up from the 130,000 views we had in 2013. Thanks again to everyone for reading and I’ll see you all in … Continue reading

Posted in Microsoft Excel | 2 Comments

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