Happy Friday Excellers. Time for some more Formula Fun. Today I want to show you how to use SUMIF in Excel to sum only the POSITIVE numbers in your data set. Let's take an...
Category: Formulas
Back To Basics. Understanding Excel Formula Errors – Formula Friday
Are you ready to get back to basics today with some refreshment of the meaning of the Excel Formula errors that you get sometimes in your worksheets?. It's time to review, and if you are new...
Six Common Mistakes Made When Using VLOOKUP Function In Excel
Hello Excellers and welcome back on this sunny evening to another #Excel #FormulaFriday blog post in my 2019 series. The VLOOKUP Excel formula or function is like a lightbulb going on when you...
Calculate Average Values Based On A Specific String In In Your Excel Data Using AVERGEIF
Hello Excellers and welcome to another #Excel #formulafriday blog post. Today let's look at how to calculate average values in Excel based on a specific text string. We need to calculate the...
Working With Time- Converting A Number Into Minutes And Seconds.
Hello Excellers welcome to another #formulafriday blog post where we will look at Excel time. Welcome back if you are a regular and a warm welcome if you are new. I invite you to follow me on...
Use SUMPRODUCT To Count Occurrences Of Specific Words In A RangeOf Cells
Hello, Excellers and Happy Friday!. Yes, Happy #formulafriday. It is time for some more Excel formula fun. Today let's look at how to use the fantastic SUMPRODUCT function to count the occurrences...