I have this formula in a spreadsheet:
=COUNTIFS($B$7:$B$998, "*"&B$2&"*" etc...
My problem is, when people add new lines to the spreadsheet for new data, the formula automatically changes.
For example, if someone added a new line, and moved row 7 down, I would want the formula to still include this new line, but it automatically updates to:
=COUNTIFS(Incidents!$B$8:$B$999, "*"&B$2&"*"
Is there anyway to stop this from happening?
Thanks!
=COUNTIFS($B$7:$B$998, "*"&B$2&"*" etc...
My problem is, when people add new lines to the spreadsheet for new data, the formula automatically changes.
For example, if someone added a new line, and moved row 7 down, I would want the formula to still include this new line, but it automatically updates to:
=COUNTIFS(Incidents!$B$8:$B$999, "*"&B$2&"*"
Is there anyway to stop this from happening?
Thanks!