How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, so I only know the start of the column is A3, but i dont know where it ends. I want to setup A2 as SUM for column A, so no matter how many data user put into column A it will auto sum them all.
I was trying to use =sum(a:a) but i can't have head in there...
Any good idea?