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.
I winced.
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.
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.
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.
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. 💁
