Home Tags Function

Tag: Function

What Is My Problem with this Excel SUMIFS Formula

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...

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...

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...

How-To Create an Excel Step Chart Formula Using the Small Function

In our last Friday Challenge, we were investigating Step Charts.  In case you missed it, you can check it out and download the sample...

How-to Make a Dynamic Hotel Ballroom Occupancy Chart

In a previous Friday’s challenge, I presented the following user request. Here was the question again and what you would have seen in the download...
Left Vlookup Formula

Excel VLOOKUP–Left or Right and HLOOKUP Up or Down

Better late than never to the VLOOKUP week as started by Mr. Excel, Bill Jelen. I have never been a big fan of the Excel...
Want to Receive the Next Post?
Join My Newsletter
Give it a try, you can unsubscribe anytime.
Privacy Policy
Subscribe Now!   (Privacy Policy)

Stay Connected!

Get the latest post emailed straight to your inbox!