Hello.
I have data on Sheet1 in blocks of rows (A3->A40, A44->A81, A85->A122, A126->163, A167->A204) and in Sheet2 I have formulas on those data
Formula:
=IF(Sheet1!$B$2="X",Sheet1!A3,0)+IF(Sheet1!$B$43="X",Sheet1!A44,0)+IF(Sheet1!$B$84="X",Sheet1!A85,0)+IF(Sheet1!$B$125="X",Sheet1!A126,0)+IF(Sheet1!$B$166="X",Sheet1!A167,0)
Formula:
=MAX(Sheet1!A3,Sheet1!A44,Sheet1!A85,Sheet1!A126,Sheet1!A167)
Formula:
=CONCAT(IF(AND(Sheet1!$B$2="X",Sheet1!A3<>0,ISERROR(SEARCH("-",Sheet1!A3))),1,0)+IF(AND(Sheet1!$B$43="X",Sheet1!A44<>0,ISERROR(SEARCH("-",Sheet1!A44))),1,0)+IF(AND(Sheet1!$B$84="X",Sheet1!A85<>0,ISERROR(SEARCH("-",Sheet1!A85))),1,0)+IF(AND(Sheet1!$B$125="X",Sheet1!A126<>0,ISERROR(SEARCH("-",Sheet1!A126))),1,0)+IF(AND(Sheet1!$B$166="X",Sheet1!A167<>0,ISERROR(SEARCH("-",Sheet1!A167))),1,0),"/",COUNTIF(Sheet1!$B$2:Sheet1!$B$166,"X"))
If I need to add a block of rows to Sheet1 (I can choose if in the beginning, in the middle or at the end) is there a way for having those new rows included automatically in the formulas in Sheet2?
I've tried adding a block of rows in the middle of Sheet1 but then the formula in Sheet2 was ignoring those new rows...
I'm attaching an example file.
Thanks!
Bookmarks