Category: Excel Formulas

7 Ways to Sum in Excel http://blog.contextures.com/ 4

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

7 Ways to Count in Excel http://www.contextures.com/xlFunctions04.html 1

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

Learn 7 ways to count in Excel, with function tips and tricks http://blog.contextures.com/archives/2015/03/26/how-to-count-in-excel/ 14

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

Excel TRIMMEAN function http://www.contextures.com/excelaveragefunctions.html 7

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

create random text in Excel http://blog.contextures.com 9

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 minimum row height 19

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

closed door brock's monument 9

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