What I want is a formula to return a BLANK entry in A1 of Workbook1, IF A1 in Workbook2 is BLANK OR IF A1 in Workbook3 is BLANK OR IF A1 in Workbook4 is BLANK ; otherwise, the SUM of all 3 cells in A1 of Workbook1 (assumes a value in each of the -3- cells).

I can get a formula to give me a #value error message based on an example from a post here on 30 Jun 09 by EVH. Just can't figure out what I'm missing.

Thanks

ray