Lastest value

[Thomas Kuriakose]

Respected Sirs,

I found the below formula which gives me the last value entered in cells. But it is ignoring zeros as the value requested is greater than zero.

=IFERROR((LOOKUP(2,1/($B2:$M2>0),$B2:$M2)),0)

The formula is not giving the result in N7, which should be 180.

Kindly let me know whether there is a better way to get the correct results for the latest values.

We also need to have a formula to get the values of a selected month. For example if we select Feb, it should display as per below-

No. of DaysFeb
300
9055
18075
36520
>36530
Total
180


Kindly guide me on this. Thank you very much.

with regards,
thomas

 

[bosco_yip]

Maybe,

1] N2, copied down :

=LOOKUP(9^9,B2:M2)

2] N7 :

=SUM(N2:N6)

or,

=SUBTOTAL(109,N1:N6)

Regards
Bosco

 

[Thomas Kuriakose]

Respected Sir,

Apologies for the late reply.

Thank you very much for the revised formula. This works perfectly.

Much appreciated,

with regards,
thomas