Forum

Okay, I used ChatGPT which said to use this more reliable date function =SUMIFS(C2:C6, A2:A6, "Chase", B2:B6, ">="&DATE(2025,6,1), B2:B6, "<...

@riny Okay, thanks I keep an eye on it

@riny I did unhide the rows and reentered previously with the same result. I just tried again removing the split screen and it didn't jump! Why woul...

@alansidman I've tried it a few times, when entering data after row 43 it jumps!

@riny That was the problem, Thank you!

@alansidman Here is it is. When I copy the data with copy/paste to a new sheet it's fine. To keep the issue I had to copy the whole sheet.

Looks like I figured it out, I modified it under calculated items!

I found this, but how do I edit it to correct?