( by Courtney Whitaker )
Now, instead of having formulas in each and every cell, you can optimize the performance of your spreadsheet by using ArrayFormulas and by reducing these excessive formulas.
Have a look at the following screenshots of sheets my spreadsheet:
I have the following formula in Cell D2 of Sheet "Main":
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.