Home Tags Function

# Tag: Function

### Why Won’t My Excel SumIFs Formula Work?!

2
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

0
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

13
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

0
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

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

### Excel VLOOKUP–Left or Right and HLOOKUP Up or Down

0
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?