Tom67KCopper ContributorMar 01, 2023SolvedHow to count Hi, need some help with below topic : - in the template, the range B1:B12 - have some numbers - want to summary on those columns , which are define by number , which is indeecated separatly eg....Show MoreOliverScheurich to Tom67KMar 01, 2023Tom67K =SUM($B$5:INDEX($B$5:$P$5,J1))This formula returns the intended result in my sheet.
OliverScheurich to Tom67KMar 01, 2023Tom67K =SUM($B$5:INDEX($B$5:$P$5,J1))This formula returns the intended result in my sheet.
OliverScheurich to Tom67KMar 01, 2023Tom67K =SUM($B$5:INDEX($B$5:$P$5,J1))This formula returns the intended result in my sheet.
Tom67KCopper ContributorMar 01, 2023OliverScheurich Have tried witha rows and failed 😞 What should I change?
PeterBartholomew1Silver Contributor to Tom67KMar 01, 2023Tom67K For me it changes the formula to= SUM(TAKE(data,1,N))
