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