Hi!

Create a list of your sheet names and give that list a name, something like
SheetNames.

Then use this:

=IF(SUMPRODUCT(COUNTBLANK(INDIRECT("'"&SheetNames& "'!E2")))........................

Biff

"Bill R" wrote in message
...
I am trying to write the formula so that If "any" of the fields; (Jan!E2)
through (Dec!E2) are blank I will get the first result; (YTD2005!F12).

The formula below only works if I only use one month that is blank, for
example (Dec!E2). When I try to enter (Jan!E2:Dec!E2) it returns the last
part of the formula. What am I doing wrong, Please?

=IF(ISBLANK(OR(Jan!E2:Dec!E2)),YTD
2005!F12,IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE)))*(360))*(F13) ),"",(SUM((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE))))*(360))*(F13 ))