If I use this on my sheet right it works fine, but then I have to use formula on the line below with different name and this happens.
=SUMIFS(Data!E4:E569,Data!C4:C569,"Operator",Data!H4:H569,"Tower D") first line
=SUMIFS(Data!E5:E570,Data!C5:C570,"Super",Data!H5:H570,"Tower D") second line
You see the second line jumps E5:E570 C5:C570 H5:H570. If I change it back to E4:E569 etc on the rest I get #Value in box. What am I doing wrong. I cant jump up a number I need to stay in range thanks.
=SUMIFS(Data!E4:E569,Data!C4:C569,"Operator",Data!H4:H569,"Tower D") first line
=SUMIFS(Data!E5:E570,Data!C5:C570,"Super",Data!H5:H570,"Tower D") second line
You see the second line jumps E5:E570 C5:C570 H5:H570. If I change it back to E4:E569 etc on the rest I get #Value in box. What am I doing wrong. I cant jump up a number I need to stay in range thanks.