number breakdown to tiers

I am fairly new to Excel but have gotten myself through to understanding a good but. So, now I have this issue with a spreadsheet for a shared water well that I use for invoicing. Problem is that I c...