Category: Excel Formulas

VLOOKUP Sorting Problem http://blog.contextures.com/ 10

Excel VLOOKUP Sorting Problem

You can use an Excel formula to pull data from a lookup table – for example, enter a product name, and automatically see its price. Be careful though, or things can go horribly wrong,...

Create a 12 Month Rolling Total http://blog.contextures.com/ 0

Create a Rolling Total in Excel

It’s easy to create a running total in Excel, and show the accumulated amount in each row. You can use the SUMIF function in a table, or show running totals in a pivot table....

Hide Formula Results Based on Date http://blog.contextures.com/ 5

Hide Formula Results Based on Date

My challenge this week was to show the running total in a list, but only for the current date and earlier. I wanted rows for future dates to appear empty, but have the formulas...

Count Items Based on Another Column http://blog.contextures.com/ 7

Count Items Based on Another Column

How can you count items in one column, based on a criterion in a different column? We’ve shipped orders to the East region, and want to know how many orders had problems (a problem...

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