I want to calculate the cost per participant. I've got my total cost per course here and I've got my number of participants up in row 36. So let's do this in C48, I press equals C46 divided by C36. That works really well in this column. I'm going to copy that into column D. That works really well here as well. But for column E, I can't copy that formula to the right because this red cell would just end up in a in a blank cell. What I could do, but this is not best practice, is I could do an inconsistent formula here, something that's not the same as those to the left. I could go E46 and then divide it by open parentheses and add the total participants together.

While this is technically correct, this is miles away from best practice. It's not gonna make my boss happy, and it's not gonna make me happy if I have to come back here in a few months time. It would be much better if we could have a consistent formula across the row, and you might notice that we've done that as much as we can in the rest of the model. I've got a consistent formula here. I've got a consistent formula here. You might legitimately say, well, hang on, I've got a completely different formula here, but that's consistent in the column.

So what I'd love to do in row 48 is I'd love to carry on this formula to the right. That's going to require me to have my total number of participants in column E here. So let's do that new heading total. I'm going to sum to the left. I'm going to use alt equals or alt shift equals, or command shift T.

I could even drag that up. I think that might be quite useful to have the total number of days as well. Now that we've done that, I can take my cost per participant that's currently in D48 and I can now drag that to the right and it works perfectly.

So now when my boss wants to check my work, they could just look in this first cell. They wouldn't have to check each cell individually.