Quote:
Originally Posted by IBRA2018
What I did I added more feeds into the Sheet 2017, starting from Project No. 2017010009 but the results doesn't reflect as it should be for the rest which is under 2017010009 .
|
1. The formulas in 4 columns on sheet 2017 (H1...H4) meant to be hidden must have an additional check. P.e.
Code:
IF(OR(ROW()=EVEN(ROW());$G6<>"In Prog");0;COUNTIF($G$5:$G6;"In Prog"))
2. The names CntCompleted, CntInProg, CntNA and CntPending I created based on your example are non-dynamic currently. Change the last row number in formula from 21 to 29 (or redesign these names as dynamic ones.
3. In Report sheet, all formulas referred to ranges like '2017'!$A$6:$A$21 or '2017'!$L$6:$L$21. Change the last row number from 21 to 29 (or use dynamic ranges instead).