Array Formula
🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/ I walk through a quick example of how to combine the ARRAYFORMULA function with other functions in Google Sheets.
I'm able to nest SUMPRODUCT within ARRAYFORUMLA once instead of writing multiple SUMPRODUCT functions throughout my spreadsheet.
Here's the link to the spreadsheet I use in the video: https://docs.google.com/spreadsheets/...
I relearned this at work yesterday, and after a bit of Googling for the proper syntax, was inspired by how powerful this was in several of my personal projects.
Hope this is helpful!
Say hey to me on Twitter: / eamonncottrell
And LinkedIn: / eamonncottrell
