1. The first thing you need to do is to open the excel table on the computer.

2, and to establish a data table with data connection.

3. Then, the elements that constitute the cost should be sorted out, and the unit consumption and unit price should be corresponding separately. Then, enter =SUMPRODUCT(B2:B17,C2:C17) in cell C18 to get the pre-tax total.

4. The next operation step is to enter =D18*1.16 in cell D19 with keyboard keys. At this time, the amount of tax payable will be obtained.

5. The last thing to do is to enter =C18+C19 in C21 cell with the keys of the keyboard. At this time, you can get the after-tax total data, and that's it.