Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Edinburgh Scotland

    Unanswered: Countif & Sumif with no match

    I have a column of data (numbers) from this colum I want to count the numbers that do not appear in the second column. I then need to sum the value in the adjecent column.

    Can anybody help? I am tearing my hair out.

    Many thanks,


  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Use a VLOOKUP to determine if the value exists in the second column. Use that as criteria for your SUMIF statement.

    ProTip: VLOOKUP returns the error condition #N/A when false. ISERROR() can be used to trap #N/A
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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