Excel: SUMIF is Outdated. Use This Instead

For as long as I can remember Excel has included a SUMIF function which is used to add up the numbers in a range of cells that match a single criteria. Being a Manchester United fan, I might need to know how many goals were scored by the team at home matches. Using...

Dynamic Dropdowns with Dynamic Arrays

In last week’s blog post and videoI covered the subject of Dynamic Arrays and how and when to use the hash sign in a formula. This week, I’m taking it a step further, tackling a real-world application of these concepts: creating an auto-updating drop-down...

Excel: Using # in a Formula

A client recently sent me an Excel file that someone else had created. That someone else had left the company and the spreadsheet needed amending. But there was an odd-looking formula in there. It had a hash sign (#) in it. My client had never seen a hash sign in a...

Excel: Create Markdown Links

This video was made in response to a real-life question. It covers how to create Markdown hyperlinks by combining the contents of two columns in Excel. So what is Markdown and why do you care? Rather than regurgitate someone else’s words, if you are interested...

Excel: Split a Cell (with Quirks)

This week’s YouTube video is based on a real-life scenario. Last week my other half Elaine Giles, an expert in Affinity Publisher, handed me an Excel file with a problem to solve. She is to spreadsheets to what I am to design. Actually I tell a lie. She’s...