Sum same cell across multiple worksheet function does not work...

R

R Hannah

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/tutorial...2-077a389706d1/send-screen-captures-into.aspx
 
S

Stefi

OK, formula doesn't sum, bur what really happens? Do you get an error message
or zero or what? Are you sure that Calculation is set to Automatic? Sheets
Protocol 1:protocol 20 have to be contiguously after each other without any
other sheets between them! Your formula is correct, you have to seek the
problem somewhere else.

Regards,
Stefi


„R Hannah†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum multiple vlookup returns across multiple columns 2
How to fill cell with data from a previous cell 2
Cant type on line E31. 4
Finding the unknown number 6
Randomly Select cell from filtered list 1
Need to separate multiple numbers in one cell 3
How to get rid of #Value when multiplying 1
N/A Error with VLOOKUP Formula - Excel 2007 6

Top