i need to sum every eight column in variable row number. For example i need to sum every eight column in row 29. The number of row must be used in the formula. Could somebody help me with this formula?
pls remove your heading Zaplaceno 1 ,Zaplaceno 2,Zaplaceno...so on in to "Zaplaceno" and than use below formula which needs to be finished with CTRL+SHIFT+ENTER
=SUM(IFERROR((D1:EW1=D1)*D2:EV31,"")) (formula highlighted in Red color)
pls referred to the attached file for better understand