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:
SUMMENPRODUKT = SUMPRODUCT
"tabObligo" is another listobject in another sheet.
Many thanks and best regards