This project has moved. For the latest updates, please go here.

Excel Error when using a sum formula on rows with numbers in adjacent cells

Mar 26, 2012 at 5:50 PM

I'm generating an excel document server side that uses a formula to sum specific cells. The formula works great, returning the proper amount, however in the cell with the formula, I'm getting a green triangle that gives the error "The formula in this cell refers to a range that has additional numbers adjacent to it". I *know* the cells adjacent to it have numbers, but they are not to be included in the total. Is there any way around this error?

For example:

cells C:18 to C:23 contain: 665, 688, 44, 21, 0, 1 and the cell with the formula (C:24) contains the value 1419 (this is correct). However, all of the cells previous in the C column also contain numbers, so I believe Excel wants to include these in the formula.

Mar 26, 2012 at 6:17 PM
Edited Mar 26, 2012 at 6:19 PM

At this version, EPPlus doesnt have any feature to help you. If you want to handle this, you need to do by your own.

Here some tips:

1) Create an excel file and reproduce all steps. Save your file.

2) Click at warning button and choose to "ignore error". Save as another file.

3) Rename your files .xlsx -> .zip and extract them

4) Compare their folders with winmerge

5) Search for files that are not identical

6) Now, you "just" need to code that tags that are not present in your first file.