SUMIFS Magic Solution
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.
(more…)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.
(more…)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.
(more…)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…
Can’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.
(more…)