I am attempting to sum the numbers from the same cell on 20 worksheets. All cells have been formatted as a number and I am using the following formula =SUM('Protocol 1:Protocol 20'!D3). When information is entered it will not sum.

BTW all of the D3 cell's have a Vlookup formula in them. Can anyone help?

EggHeadCafe - Software Developer Portal of Choice
Send Screen Captures Into A Database
http://www.eggheadcafe.com/tutorials...ures-into.aspx