=IF(Weekly!D70<"",Weekly!D70,IF(Weekly!C70<"",We ekly!C70,IF(Weekly!B70<"",Weekly!B70,0)))

"japc90" wrote:

I am using this formula =IF(Weekly!D700,Weekly!D70,IF(Weekly!
C700,Weekly!C70,IF(Weekly!B700,Weekly!B70,0))) so that a summary
spreadsheet will update with the most recent column of data.

The issue I am having is that occassionally cells will be zero and I
need that data pulled into the summary spreadsheet. With this formula
though it looks at the zero and then goes to the next cell. How can I
make it pull in the zero.

All of the cells not filled in will be blank. Is there a formula that
would do the same thing but skip blank cells instead of looking for
cells with values greater than 0?