Wouldn't this work, just entering it into a cell & substituting A with the letter of the column you're working with? 
=SUM((A:A)-A1)