If headings are in row 1 and data starts in A2, put this in E2:

=LOOKUP(10^100,A2:D2)

Will return the last non-zero entry in the range.

Hope this helps.

Pete

On Feb 13, 1:39*am, sue wrote:
week1 * *week2 * week3 * week4 * *total
1500 * * *3000 * * * * * * * * * * * * * * * 3000
the total column picks up the last column other than zero



"Tyro" wrote:
Well, first of all, no caps, please. It is considered yelling. Secondly give
us an example of your data and what you want to see as a result. We are not
deaf mind readers.

Tyro

"sue" wrote in message
...
I have *week1 *week2 *week3 week4 total
I want a formula and/or function to pick up the last week populated with a
higher amount than null/zero into the total field- Hide quoted text -

- Show quoted text -