Results 1 to 2 of 2

Thread: countifs

  1. #1

    countifs



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

    Hello,
    Formula IF(ISNUMBER(SEARCH("sub",$E1916)),"YES","NO")) I have added to it the first countifs function below to count any repeated values in column AJ as one and by day (column A), so that if the repeated value in AJ column is also repeated on a different day, it doesn’t include it in the counting. But it is not working. Am I missing a countif before the countifs? Much appreciated

    =IF(COUNTIFS($A$2:$A1916,$A1916,$AJ2:$AJ1916,$AJ1916)=1,IF(ISNUMBER(SEARCH("sub",$E1916)),"YES","NO"))

  2. #2
    In what way is it not working, what do you get?

Tags for this Thread

Posting Permissions

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