Dear experts
I have four types table range In which i have to fill the formula depends upon row and column header labels the tables row and column labels values the raw data has connect to get result in sumifs and count ifs function i want fill the formula till header values ends up in each range.
Table1 Start at C5=SUMIFS(Rawdata!$G:$G,Rawdata!$D:$D,$B5,Rawdata!$A:$A,C$4)-SUMIFS(Rawdata!$I:$I,Rawdata!$C:$C,$A5,Rawdata!$A:$A,C$4) end till row 4 header
Table2 Start at C20=SUMIFS(Rawdata!$H:$H,Rawdata!$C:$C,$B20) end till row header 19
Table3 start at C31=SUMIFS(Rawdata!$I:$I,Rawdata!$E:$E,$B31,Rawdata!$C:$C,C$30) It might get extent depends upon row text value in row 30 in the row 31 the formula has to fill
Table4 COUNTIFS(Rawdata!$J:$J,$V4,Rawdata!$B:$B,W$3) Till end of row header 3
find the attachment. you may understand what i looking for.
Bookmarks