Say there is a cell B10, I want to put a formula in C10 that will sum up everything in column A from A9 upwards UNTIL I hit a zero.

Please help me, lives are in danger