Here's how to sum random cells . So we're doing some analysis in our Google Sheets and we see, oh, we have bananas, cherries, and dates, and we can select these cells and say, okay, what's the sum of them? And here we have on the bottom, a little explorer here, and it says sum seven. So we don't really have to hard code that, but let's say we want to select bananas, dates, and figs, and the price and add it up. You can hold down the command key. So I'm going to select bananas, then hold command, and I'm going to select dates and figs as well, and see, holding down command, Means I can select each of these different cells that are not next to each other. And here the sum is 7.30.

What if I wanted to do that in a formula ? There's a couple ways to get a sum here. We can do equals, and we can just select the cell, add a plus sign, and then select dates, add a plus sign, and put figs here. Maybe this formula is a package, package one. And if we wanted to create another one We can put package two here equals this plus select another, maybe grapes plus honeydew. And there's a different package. We can also use the sum formula . Sum formula just has us add up different values . So we still need to select those same values. Let's say we selected Bob's bananas.

We need a comma separating maybe the grapes. Dana's dates and another comma and Fiona's figs here. And that way we get some of these different cells . But what if we wanted to actually randomize this? Which is very interesting because sometimes when we say random cells we just mean cells that are different locations. They're not all together. But actually, what if we wanted to put together a mystery package of sorts? Well, what we're going to need to do is use index . Now, index is really funny because it's just saying, hey, this is me. Give us the row and column of a range . So if I have a price here, this range , and I select the second row and the first column, it's going to give me two dollars, which is right here.

It's the second row and the first column of this range . So we can actually randomize, let's say, this number two. How do we do that? Let's select a very specific range , D2 to D9, and instead of the number two, I'm going to say rand between. And the lowest number is going to be one and the highest number is going to be eight. And now I can get a random number here. This is 2.80 cents. This is probably this figs here. Now, every time I edit the sheet, you'll notice this ran between changes because this is sort of a formula just continually updates every single time the sheet itself is updated, either.

Editing a cell, editing a cell on another page. This ran between won't stay the same. So if we want to just initially get a random one, we can say, let's select the D2 to D9 and keep it. So like, put those dollar signs there so it won't change. And if I copy paste this, You'll see them all changing, but now we have random ones, each one is random. So we got 3.50 here, that's this one, 3.50, that's also this one, 1.50, this one, right? So this is a funny way, but an interesting way to actually sum random cells , because now we can select any number of these. We can say sum a random, and then another random, maybe three randoms. And we're adding together three random ones each and every time.

We don't, maybe we don't necessarily know which ones are actually, uh, added together here. But we do get a random 3 together. It could actually be the same one over again. Something like 10 might be 4 two times and then a 2 one. So that was a funny way to sum random cells . And I think one of the key things you might know now is you can choose the command key and hold it down and sum up the number . different cells . So I think that's pretty cool. Hope you enjoyed this. If you're looking to get more out of your Google Sheets, do awesome stuff in Google Sheets,. Make your Google Sheets life better. Subscribe here on YouTube to better sheets.