I am facing issues with some of the functions and not able to execute

In the below table, find the sum of total sales. The formula should ignore hidden cells and subtotals and errors Also some the sequence function is not giving the correct results in both google sheets and excel