I am getting the green dropdown error because in cell k2 I am using =sum(L2:L52) for a specific range but I have another range on numeric values below L52
I can solve it by changing the formula =sum($L$2:$L$52) but it's not helpful as I have to copy the same formula in other cells
one more option is that I can leave a blank row below L52 (keep row 53 as blank) but this doesn't look good in my sheet as I have 3000 entries, which means I have to keep 3000 blank rows.
is there a way to fix it?
I can solve it by changing the formula =sum($L$2:$L$52) but it's not helpful as I have to copy the same formula in other cells
one more option is that I can leave a blank row below L52 (keep row 53 as blank) but this doesn't look good in my sheet as I have 3000 entries, which means I have to keep 3000 blank rows.
is there a way to fix it?