Forum Discussion

Copper Contributor

Jul 26, 2022

sumif

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

Diamond Contributor

Jul 26, 2022

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