Download Excel File: https://ift.tt/34dcAS1
Learn how to join multiple items from different rows and columns into a single cell using an array operation with the Ampersand, the TEXTJOIN Function and the TEXT Function to correctly format the numbers for a single cell text label.
Topics:
1. (00:01) Intro
2. (00:29) Revenue Formula with data from different rows
3. (03:02) Expenses data coming from different columns
4. (03:44) Bonus Formulas
5. (03:30) Summary