How to remove a row from a calculation on Excel?

Originally Posted by AlKey

if you apply filter, this formula will sum only visible cells and ignore hidden.

Please see attached file with Group feature (on the left) where you easily hide/unhide first row.

Thank you very much!