Forum Discussion

FoliniCarlo's avatar
FoliniCarlo
Copper Contributor
Feb 14, 2021
Solved

Wrong formula recalculation on dynamic table

Hi, I have a table with 3 columns (excel 2013). The last column has a formula that computes sum of "value" column from previous rows with same "product" name. This tables auto expand, but formula is...
excel
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Feb 14, 2021

    FoliniCarlo 

    One possibility is to give up the practice of direct cell referencing entirely and use structured references throughout.

    = SUMIF(
    INDEX([Product],1):[@Product], 
    [@Product], 
    INDEX([value],1):[@value]
  )
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Feb 14, 2021

FoliniCarlo 

One possibility is to give up the practice of direct cell referencing entirely and use structured references throughout.

= SUMIF(
    INDEX([Product],1):[@Product], 
    [@Product], 
    INDEX([value],1):[@value]
  )
  • FoliniCarlo's avatar
    FoliniCarlo
    Copper Contributor
    Feb 14, 2021

    Thanks PeterBartholomew1 it works perfectly!

     

    Italian translation for your formula

    =SOMMA.SE(INDICE([Product];1):[@Product];[@Product];INDICE([value];1):[@value])

Resources