If function or something else?

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

I am using 12 cells to show balances for the 12 months of
the year. In Cell 13, I want to insert a formula that
would show January's total if the sum of Feb thru Dec =
0. Once Feb has a total, I want Cell 13 to show
February's balance. Then March's balance once March's
total is entered. Basically, Cell 13 would show the
balance for the most recently month that has a balance
greater than 0. I tried using an IF formula but Excel
didn't like the way I was entering it. Thanks for any
help you can give me.
 
Hi
if your data is in column a try the following formula in A13:
=INDEX(A1:A12,SUMPRODUCT(MAX((A1:A12<>0)*(A1:A12<>"")*(ROW(A1:A12)))))
 
Back
Top