Excel Formula that doesn’t repeat when you use drag and fill

I’d like to create a formula for a spreadsheet and populate all the line items without having the formula repeat over and over. Someone did it in one of their spreadsheets but would not share how he did it.

Thanks,
Susan