I have a data sheet that lists all of the activity by day for an entire year
with a weekly summary. I then want the weekly summary to be populated on a
seperate sheet for the row that has data in it.
For instance the sheet would look at row 100 if there is no data it would
look at row 99, if there is no data in row 99 it would look at row 98 and so
on until it found the row with data in it.

"bpeltzer" wrote:

From Excel's help: "A formula can contain up to seven levels of nested
functions". You're well past double that. Half the nesting levels could be
eliminated by removing the ( before each 'if'. But you'd still be over the
limit.
Can you tell us more about what's in column AA? For example, can you be
certain that if a given cell is populated with a value 0, that all the
cells above it are also populated? Will they either have no value or a
number 0? ...


"ladyhawk" wrote:

Can anyone tell me what is wrong with the formula below:
=if(Data!AA910,Data!C92,(if(Data!AA910,Data!C85, (if(Data!AA780,Data!C78,(if(Data!AA710,Data!C71, (if(Data!AA640,Data!C64,(if(Data!AA570,Data!C57, (if(Data!AA430,Data!C43,(if(Data!AA360,Data!C36, (if(Data!AA220,Data!C22,(if(Data!AA150,Data!C15, Data!C8))))))))))))))))))