Wait till AI is able to help.
=TEXTJOIN("",TRUE,A330,A443,A556,A669,A782,A895,A1008,A1121,A1234,A1347,A1460,A1573,A1686,A1799,A2112,A2225,A2338,A2451,A2564,A2677,A2790,A3303,A3316,A3329,A3342,A3355,A3368,A3381,A3394,A5407,A5420,A5433,A5446,A5459,A5472,A5485,A5498,A5511,A5524,A5537,A5550,A5563,A5576,A5589,A5602,A5615,A5628,A5641,A5654,A5667)
OMG. Which AI tool produced this?
Claude. To be fair, it had trouble OCR-ing it. After way too much back and forth about the pattern, it produced this:
=LET( rows, SEQUENCE(INT((667-30)/13+1),1,30,13), SUM(INDEX(AA:AA,rows)) )
Which is correct, but obviously the calculations would be best served by reorganizing the table and probably using a pivot table or at least grouping and subtotaling.
Wait, that’s an actual formula. When I first saw this I thought it was an employee going insane and keysmashing into a spreadsheet as evidenced by the “send help”.
Yup, actual formula. Might not even be the most offensive one in the spreadsheet.
I winced.
Resume: “Experienced Excel Wizard”
virgin =SUM() users vs chad click at each cell enjoyers
What is even happening here? There is a sum of like every 13th cell?
I guess this is Excel.
Every 13 cells could be summing the total of multiple years of data. Eg 12 month + 1 total, rinse and repeat. Then summing just the total cells for each year. 💁
My guess is that there are multiple tables on one sheet, and this is the summation of the sub-totals.
Multiple things formatted to look like tables, but not actually tables. And they are summing like every 13th cell. It is wild over here.