You may be well-accustomed to using cell references in Excel, but did you know you could go one step further and create your own cell references? This is where the INDIRECT function comes in handy.

If you have a spreadsheet where multiple cells contain the same text, you can quickly count them. Here are two ways to do it in Google Sheets that also work in Microsoft Excel. This guide comes from ...