<div>
can you upload the dummy file?
</div>


<div>
I would check the value of the items in that other sheet, make sure that the cels are formatted for the right data type?
</div>


I would check the value of the items in that other sheet, make sure that the cels are formatted for the right data type?

<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
I have a strange behaviour in Excel. I am using a list object with formulas that are referencing columns inside the list and columns in another list. Every reference is absolute or based on the column names.<br />
<br />
Until a specific row of the list object everything is ok, but in the next line I suddenly get #VALUE errors. I double checked all cell values. Everything is the same as in the row that is ok.<br />
When deleting a row above the row with the error - the row with the error is ok now...strange...<br />
<br />
Any idea, why this happens? Are there any limits? I am using Excel 2013.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/10_w42/877195/13-10--2014-16-38-00.png" target="_blank" title="screenshot with error and non-error rows (8 KB)"><img alt="screenshot with error and non-error rows" class="file-block lazyload" style="max-width: 533px;" data-src="https://filedb.experts-exchange.com/incoming/2014/10_w42/877195/13-10--2014-16-38-00.png" /></a><br />
Formula in Column &quot;Bestellsumme&quot; in error AND non-error rows is:<br />
<br />

<pre><code id="code-10-28536505-1">=SUMMENPRODUKT((tabObligo[RefBelegnr]=[@[Bestell-Nr.]])*(tabObligo[Plan/Kw])*(tabObligo[Kostenartgruppe]=[@Kostenart]))*(tabObligo[Jahr]=[@Jahr])</code></pre>
<br />
SUMMENPRODUKT = SUMPRODUCT<br />
&quot;tabObligo&quot; is another listobject in another sheet.<br />
<br />
Many thanks and best regards<br />
<br />
Ralph
</div>
</div>


13-10--2014-16-38-00.png

Hi there,

I have a strange behaviour in Excel. I am using a list object with formulas that are referencing columns inside the list and columns in another list. Every reference is absolute or based on the column names.

Until a specific row of the list object everything is ok, but in the next line I suddenly get #VALUE errors. I double checked all cell values. Everything is the same as in the row that is ok.
When deleting a row above the row with the error - the row with the error is ok now...strange...

Any idea, why this happens? Are there any limits? I am using Excel 2013.



Formula in Column "Bestellsumme" in error AND non-error rows is:

(CODE)

SUMMENPRODUKT = SUMPRODUCT
"tabObligo" is another listobject in another sheet.

Many thanks and best regards

Ralph

#VALUE Errors in Excel List Object

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.