A client recently had a problem. He was chasing a formula that identified if a text string contained one of three words. He wanted to base an allocation on finding those three words. SUMIFS offers a solution.
Monthly Archives: May 2024
If you knew how much effort went into it you would not call it genius.
Michaelangelo
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.
“Everything not saved will be lost.”
Nintendo “Quit Screen” message
A New Month of Sundays
One of my more popular posts involved counting the number of Sundays between two dates. With dynamic arrays that becomes easier, and we can create a custom function.
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 2024Can’t push objects off the sheet Error in Excel
I recently had an error pop up when working with a client’s file. The client’s file had a macro that would hide most of the columns on the sheet, but it had started to generate an error message.
Deeds will not be less valiant because they are unpraised.
Source: Aragon in The Return of the King
J.R.R. Tolkein