# CHECKSUM Formula in three months giving false reading in one of them

1. ## CHECKSUM Formula in three months giving false reading in one of them

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

2. ## Re: CHECKSUM Formula in three months giving false reading in one of them

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

3. ## Re: CHECKSUM Formula in three months giving false reading in one of them

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

4. ## Re: CHECKSUM Formula in three months giving false reading in one of them

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

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1