How to calculate the sum of numbers in a column through a query, not counting some other cells?

Question

Google Sheets

there is a column and there are numbers 1 2 3 4 5 5 1 2 3 4 6 5 5 1 2 6 7 8
5 very grateful if this data were in columns it would be much easier but this is a table and there are a lot of such columns and in the skin it is necessary to consider this

Answer 1

I won’t tell you about Google, but in Excel there is a formula = SUMMESLI (A1: A8; "<> 5"), there should be an analogue in Google sheets.