Excel Tips


Sum A Cell Through Several Worksheets »

March 3, 2021

You have 12 identical worksheets, one for each month. You would like to summarize each worksheet. Is there a better way than using =Jan ! B4 + Feb! B4+Mar! B4+Apr! B4…?


Use Natural Language Formulas Without Using Natural Language Formulas »

February 24, 2021

Excel 2003 offers relatively obscure natural language formulas, but they were removed from Excel 2007. The table nomenclature in Excel 2007 isn’t as easy to use.


Always Point To Cell B10 »

February 17, 2021

You want to create a formula that always points to cell B10. Normally, if you have a formula that points to B10 or even $B$10, the formula changes if you cut and paste B10 or if you insert or delete rows above row 10.


Use Indirect To Get A Data From A Multi-cell Range »

February 15, 2021

INDIRECT is pretty cool for grabbing a value from a cell. Can INDIRECT point to a multi-cell range and be used in a VLOOKUP or SUMIF function?


Get Data From Another Worksheet By Using Indirect »

February 12, 2021

You have 31 daily worksheets in a workbook, 1 for each day of the month. A cell on the summary worksheet contains a date. You want to use the date cell in INDIRECT to grab data from a certain day’s worksheet, but the formula always returns a #REF! error.


Point To Another Worksheet With Indirect »

February 10, 2021

You need to grab cell B4 from one of many worksheets. You have to determine which worksheet, based on a cell label or a calculation, and you’re wondering if INDIRECT can point to another worksheet.


Refer To A Cell Whose Address Varies, Based On A Calculation »

February 8, 2021

You need to refer to a cell, but the cell address varies, based on a calculation.


Use Get Cell To Highlight Non-formula Cells »

February 5, 2021

You want to highlight all the cells on a worksheet that do not contain formulas.


Understand Boolean Logic: False Is Zero; And Is *,or Is + And Everything Else Is True »

February 3, 2021

You want to become a guru at Excel formulas. To master conditional computing formulas, you need to understand Boolean logic facts.