consider the following situation I have in one of my worksheets where I am trying to add various cells in the same row:
="Production YTD "&TEXT(SUM(D67,H67,L67,P67,T67,X67,AB67,AF67,AJ67,AN67,AR67,AV67),"$ ##0.00")
Is there a way to simplify the sum of multiple cells in the same row or in the same column without having to list each cell location. note that the cells are not consecutive.
="Production YTD "&TEXT(SUM(D67,H67,L67,P67,T67,X67,AB67,AF67,AJ67,AN67,AR67,AV67),"$ ##0.00")
Is there a way to simplify the sum of multiple cells in the same row or in the same column without having to list each cell location. note that the cells are not consecutive.