Function
Why Won’t My Excel SumIFs Formula Work?!
Part of my time this week was spent working on a project for a client and I was sooo frustrated. I just couldn’t get my SUMIFS formula to work. Have you ever had that issue with an Excel fu
EXPLORE THE LIBRARY
Tag: Function
Help
How-to Quickly Get Excel Function Help Plus a Bonus Tip
In a recent post, I was exploring Excel AverageIF and other Average functions and I realized that I don’t know that much about the AverageA Excel function. So I thought I would share how I q
Averageif
How-to AverageIf Excluding Zeros and Blanks for Non-Contiguous Ranges in Excel
In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude blanks and zeros. This came from a user questio
Chart
How-To Create an Excel Step Chart Formula Using the Small Function
How-to create your step chart data with a formula using SMALL and VLOOKUP. Check it out in the Step-by-Step, Video Tutorial and Free Sample File Below.
Challenge
How-to Make a Dynamic Hotel Ballroom Occupancy Chart
See how to create a hotel occupancy chart using advanced date functions, countif formulas and conditional formatting. Also included is finding out how many days are in any month and if any d
Dashboard Design
Excel VLOOKUP–Left or Right and HLOOKUP Up or Down
Understanding and learning the Left Vlookup functionality in Excel by using Index/Match Functions and Formulas