If I follow you well, and your data is in A2:B4 (row 1 is for headers) then netsales could be calculated as:
Formula: copy to clipboard
=SUMPRODUCT(A2:A4*(1/(1+B2:B4)))