How To Use ARRAYFORMULA For Magic
Learn how to use ARRAYFORMULA in Google Sheets to efficiently calculate the revenue from sales without manually copying formulas. This video demonstrates the power of ARRAYFORMULA for handling multiple rows at once.
we want to get the product of the amount of sales and the price here. 'cause we wanna get the revenue and that's going to be this times this, right? B two times C two. And we could copy paste this all the way down. But let me show you how to use array formula to do this. Very simply, we do equals array formula and it's a very long formula , but it allows us. To do B two, colon B six times C two colon C six. And what this is doing is changing the format from a single cell to an array. That's why it's called Array formula . It's changing the formula from a single product to the product of each of these.
So we hit enter and immediately we have all of these products that is 140 times 45. And if we insert a row below here, look, it's already here. The formula is going to show up. So maybe we say Tuesday B, and we go a hundred and we sold 'em for 40 there. That is a pretty awesome way to do something. Pretty simple. But in a very simple way, right. Array formula . Yeah. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here.
Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.