How To Sum Entire Column Except Header/First Row In Excel
=SUM(A2:INDEX(A:A,ROWS(A:A)))
OR:
=SUM(OFFSET(A2,,,ROWS(A:A)-1))
OR:
=SUM(OFFSET(A2,,,ROWS(A:A)-1))
Remove everything AFTER string in Notepad++
i/p: srinivaskuamrgoud wants to delte after goud test and all o/p: srinivaskuamrgoud use below method.
Comments
Post a Comment