You can get around the 7 nested If statements limitation a few
different ways. This web page gives direction on how to do it.

http://www.cpearson.com/excel/nested.htm



Niek Otten wrote:
What's your data layout/what is on which sheets? What are you trying to sum?
What did you try so far? Did it work for <7 If's?

--
Kind regards,

Niek Otten

"Rachel S" <Rachel wrote in message
...
I'm stumped...I need a formula for a Year to date worksheet that
references
each MTD worksheet and grabs the most recent value. The only way i know
how
to do this is through IF's but the limit won't allow for it. Any ideas?