Forum Discussion

Aboudy's avatar
Aboudy
Copper Contributor
Jul 26, 2022

sumif

dear 

 how to keep the sumif formula counting when I add more data on the sheet. 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Aboudy 

    You may use structured tables and use in formula structured references. Or use dynamic ranges in formula.