Bob,

I don;t know the wider context in which you want to use it, but the
following formula will sum the rightmost 2 numbers in a row. If there
is any text it is ignored.

The following *array* formula (commit with Ctrl+Shift+Enter) will
calculate the sum for data found in row 1.

=SUM(N(INDIRECT(ADDRESS(1,LARGE(IF(ISNUMBER(1:1),C OLUMN(1:1)),
{1,2})))))

HTH
Kostis Vezerides

On Oct 10, 6:44 pm, "Bob Dowell" wrote:
I need find the last two cells in a row that contain a number,and use the
sum of those numbers in an average. This will be part of a IF function.

Thanks in advance,
Bob