Formula that will skip one column when calculating SUM() or similar functions

I'd like to run a =SUM(A1:G1), but always skip one column, regardless if it has value or not. In this case, it should calculate A1+C1+E1+G1.

Is there another function I could append to SUM() or other similar functions as SUM in order to skip one column?

Thank you!

https://stackoverflow.com/questions/65538566/formula-that-will-skip-one-column-when-calculating-sum-or-similar-functions January 02, 2021 at 07:26PM