Thread: SUM help please
View Single Post
  #1   Report Post  
ExcelNoob123 ExcelNoob123 is offline
Junior Member
 
Posts: 3
Default SUM help please

I have created a sheet which is tracking 3 items per client and a number of clients so I have set up a SUM function the only way I know how which is a long a1+a4+a7, etc
Its works fine, but if I want to add a new client and 3 new rows, ALL of the + after are now off.

Is there a better way to create a formula that will track say every 3rd cell in a column but then let you lengthen or shorten the column?

Thanks!!