Category: Excel Formulas

Option Button Scores With CHOOSE Function

You can use option buttons on a worksheet, to make it easy for people to pick just one item from several options. There’s no programming required – just set up a group box, add...

Beware the Nested IF Formula in Excel

Do you use the IF function in your workbooks?  It’s helpful if you want to check something, and then show a result based on the result of your test. But, things can go horrible...

7 Ways to Sum in Excel

What was the first function that you learned in Excel – if you can remember that far back? I’ll bet it was the SUM function. There’s an AutoSum button on the Ribbon that makes...

Compare Excel Worksheet Values and Formulas

If Excel sheets are set up identically, you can create 3-D formulas, to sum a specific range, in a group of sheets. (You can use other functions in a 3-D formula too, such as...

Counting in Excel

The most popular function in Excel is SUM, based on my experience. That’s probably the first function you learned how to use, and in the old days, it was the only function that you...

How to Count in Excel

There are lots of different ways to count things in Excel – maybe you need to count the numbers in a column, or all the data, or just the blank cells. Fortunately, there is...

Ignore Outliers with Excel TRIMMEAN

From what I’ve seen in workbooks over the years, SUM is the most frequently used Excel function, and AVERAGE is the runner-up. Would you agree, or do you see other functions used more often...

Football Fun in Excel

This Sunday is Super Bowl XLIX – the last one that will start with "XL".  Next year, it will be Super Bowl L – that doesn’t exactly roll off the tongue! In 2011, I...

Count Activities in a Date Range

Today’s challenge is to count how many guests stayed at a hotel, in a specific date range, based on the guest arrival and departure dates.

Create Random Text in Excel

Last week, I was creating an Excel file with sample data, to use for a few experiments. But don’t worry, they weren’t mad-scientist-type experiments – I was doing Power Pivot experiments, and needed some...

Set Row Height With REPT Function

Thanks to AlexJ for suggesting a great use for the REPT function – setting a minimum row height. He uses this technique to add a bit of spacing in his tables, so they’re easier...

Auditing Excel Formulas Quick Tips

For the past couple of weeks I’ve had lots of trouble with this blog. It’s been up and down, and I’m sorry if you’ve come to visit, and found the doors closed! The sturdy-looking...