Try this:

=IF(COUNT(A1:R1),LOOKUP(1E100,A1:R1),"")

It'll return the rightmost number in the range. If no numbers are present
it'll return a blank.

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Sorry I forgot to mention that there may be negative numbers infrequently.

Cheers

"TUF" wrote:

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

Are there any 0s in the range? Will the numbers always be positive
numbers?

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
HI,

I have rows of figures under monthly categories, i.e. Jan, Feb, Mar
etc. .
,
there are empty cells within each row (approx 18 columns wide).

What I am trying to get is a formula that reads the last entry in the
row
even if there are empty cells on either side of it

Thanks