The Cashflow and Transaction sheets on the attached have matching Closing Balances in Oct, Nov and Dec.
The CHECKSUM formula in row 52 of the CASHFLOW sheet compares each month's closing balance to that on the TRANSACTION sheet:
=SUMIFS(Table1[Balance],Table1[Date],AGGREGATE(14,6,Table1[Date]/(Table1[Date]<=EOMONTH(D4,0)),1))=D48
You can see that it agrees they match in Oct and Dec, but Nov shows as "FALSE" when it isn't?
Hope someone can see the problem?
Ochimus
Last edited by Ochimus; 02-03-2019 at 08:07 PM.
There are 5 records on 21 Nov, sumifs sum all these.
If you want only last records please try at
C52 drag to the right
=VLOOKUP(EOMONTH(C4,0),Table1,7)=C48
Bo,
Proved the value of this site yet again, seeing at first glance what I had missed completely!
Many thanks, and can now close this thread as "Solved"
Ochimus
Happy to help.
Thank you for the feedback and mark topic Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks