Solving a Conditional Summing Text Problem in Excel

I was checking out an old Excel book Excel Outside The Box by long time Excel MVP Bob Umlas and noticed he used the N function in his SUMPRODUCT functions. I then realised why. It converts text to a zero. That gets around an issue with adding up ranges that contains text, thanks again Bob.

It’s  so hard to forget pain, but it’s even harder to remember sweetness. We have no scar to show for happiness. We learn so little from peace.

Chuck Palahniuk (Novelist)

May the Macros Be With You

May is Macros month.

You can learn how to save time and effort by replacing repetitive or time consuming tasks with a macro. Macros make delegation easier.

Four live Excel webinars to get you started with macros. The first one is free. Over 5 hours of training.

Buy the Essential Macros Bundle for AU$60 and be registered for all the live May sessions (see below for dates) plus get access to the online courses including bonus macro content.

Essential Macros Bundle 2024