Formula to find first non zero value in a column

Originally Posted by chinchillin

Hi Glenn,

Thank you your formula works but only if the 0 is on the right hand side of the column not the left. Ive attached a screenshot with the formula I used to calculate those 0s. As you can see at the very bottom of the screen shot my output is still 0 and not 5200 as I'd like it to be. Any ideas?

Late to the party here, but your formula should be

=IF($C$2:$C$51<$B$5,0,(ugly thing in parens))

with the zero NOT in quotes. This returns zero as a numerical value, not a text label.