Alright, so we're gonna do a formula here. So let me go ahead and do a quick shortcut, alt equals is going to calculate the sum here. And I'm looking to divide each of these contracts signed up by two, four. So when I type the formula equals contracts signed here, 22 divided by the gross right there, g 10. That is the correct answer of what I'm looking at 12%. The problem is going to be if I try to copy the formula down, I'm going to run into big time trouble, because what's going on here is that every time I copy down, the formula goes down to along with it.
That's great on the contract signed up. I want to still be at the end of the rope here and still divide 27 divided by g 10. Still right there. So how How do I do that? Well, the answer is pretty simple here, you're going to want to put absolute referencing on the formula. So in this scenario here, I'm going to change my formula so that it's the dollar sign, g dollar sign 10.
And it's really the 10th row that I'm locking down to $1 sign that represents absolute reference means I'll always reference the 10th row no matter how far I direct down and I can copy that on top of the others to get that Okay, so that is one way to do absolute reference is put the dollar signs in front of it. Also could have did this I could have just straight up type equals g to I'm clicking on it divided by g 10. Then I'm gonna hit f4. To put the dollar signs in there, every time I hit f4. It rotates through absolute referencing the row Call them or not. And so that's what I want right there.
And I can copy that down. Just like that. A cool trick is we can do range names, come over here, that 10% come over and call it commission. So now I have a range name called commission, which is taking the placement of a one and anytime I want to multiply it, that is that's commission right there. That's the name that's it times sales here and that is going to be referenced all the time right there cool thing then if I need to update the commission rate, then they all will change with it here.