I know this shouldn't be this difficult, but what I am looking to do is

I want a total in A5 based on a running total in A1 through A4.

For example, if A4 is blank then input A5=A3, if A3 is blank than A5=A2, if A2 is blank then A5=A1. If there was a value in A4 than A5=A4.

Thanks!

Thought:

IF(A4>"0",A4,A3),IF(A3>"0",A3,A2),IF(A2>"0",A2,A1),IF(A1>"0","A1",0))