9 Replies Latest reply on Jun 8, 2012 9:28 AM by Jonathan Drummey

    Count value only where another value is unique

      Hope someone can assist me with this problem:

       

      I have a data sheet containing participants in an online promotional campaign. The data is set up this way. I am filtering on date.

       

      Date&Time Emailnewsletter opt-in
      5-1-2012 10:001@domain.comyes
      5-1-2012 10:01
      1@domain.com
      yes
      5-1-2012 10:022@domain.comno
      5-1-2012 10:032@domain.comno

       

      I'm counting unique participants by COUNTD(Email)

      and newsletter optins using a boolean:

       

      IF ([newsletter opt-in]="yes")=TRUE

      THEN 1

      ELSE 0

      END

       

      Now I want to count the number of 'yes' entries in the newsletter opt-in field, but only for unique email addresses. I can't use filters because I'm filtering other fields in the same sheet on date. Can anyone tell me how to do this?

       

      Thank you in advance!