Philip Florio
Eminent Member
Joined: Jun 14, 2025
Last seen: Jul 9, 2025
Last seen: Jul 9, 2025
Follow
RE: Lookup a name in column by date range along with totals
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, "<...
3 weeks ago
Replies: 3
Views: 138
Replies: 1
Views: 171
RE: table skipping rows
@riny Okay, thanks I keep an eye on it
1 month ago
RE: table skipping rows
@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...
1 month ago
RE: table skipping rows
@alansidman I've tried it a few times, when entering data after row 43 it jumps!
1 month ago
RE: Cannot format Date in Table
@riny That was the problem, Thank you!
1 month ago
Forum
RE: Cannot format Date in Table
@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.
1 month ago
Forum
RE: Budget Template / Pivot Table / Income Surplus/(Deficit) Total Problem
Looks like I figured it out, I modified it under calculated items!
1 month ago
Forum
RE: Budget Template / Pivot Table / Income Surplus/(Deficit) Total Problem
I found this, but how do I edit it to correct?
1 month ago
Forum
Forum
Replies: 2
Views: 294