Excel - INDIRECT Function 

In this video I describe how to use the INDIRECT function to automate calculations with data in other worksheets.
I use as support the COUNTIF and OFFSET
Example Worksheet (No functions)
drive.google.c...
Example sheet (Filled)
drive.google.c...
I hope you enjoy the video. If you like, share it. Questions, post in the comments ...
Until our next video.