+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,263

    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
    Attached Files Attached Files
    Last edited by Ochimus; 02-03-2019 at 08:07 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    6,272

    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. #3
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,263

    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. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    6,272

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Cells not reading as numbers when average is used. Giving #VALUE! error.
    By greenfox74 in forum Excel General
    Replies: 4
    Last Post: 02-18-2018, 03:22 AM
  2. Hexadecimal Checksum formula.
    By danieljgor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-07-2016, 08:56 AM
  3. True or false formula giving wrong result for null and blank values
    By aniletc37 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2016, 04:20 AM
  4. Dynamic formula in VBA giving "FALSE" as return
    By kmlloyd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2015, 11:24 AM
  5. =If formula giving a false return
    By Jogier505 in forum Excel General
    Replies: 7
    Last Post: 03-04-2011, 05:20 PM
  6. Reading/lookup Data from excel by giving a querry
    By helloexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2008, 07:13 PM
  7. Figuring out checksum formula..
    By djvice in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-28-2007, 07:54 PM

Bookmarks

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