Assuming that the months are in Columns B:M try:

=IF(COUNT(B2:M2)=0,"",LOOKUP(10^10,B2:M2))

to return the latest month's figure and copy down as required

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jennifer" wrote in message
...
I have a sheet with all 12 months and then I have a column next to the
total
column that displays the data from the newest month.

Ex.

May Jun | | Total
1 1 1 2
1 2 2 3

The column that displays June's data again basically makes it easier for
me
to look at and manipulate later.

Is there a way to automatically have that column update if I add data in a
July column?