Results 1 to 4 of 4

Thread: countif error

  1. #1

    countif error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have the a COUNTIF function used on one workbook which refers to another workbook, however I get the result #value! unless the other workbook is open - this is even if I chose to update links when I fist open the file.

    Do all workbooks have to be open when using COUNTIF?

    If I open the other workbook after my workbook with the COUNTIFs on has been opened then all #value! errors disappear and the correwct info is shown.

  2. #2
    Yes, you could use SUMPRODUCT instead

    =SUMPRODUCT(--([filename]sheetname!range=value))

  3. #3
    Thanks for your reply. What does =value mean?

  4. #4
    ARe you kidding? Didn't you use it at the start of your COUNTIF formula?

Posting Permissions

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