sumif

Occasional Visitor

dear 

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

1 Reply

@Aboudy 

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